Podcast
Questions and Answers
Ctrl+F4 is used to close the current ______.
Ctrl+F4 is used to close the current ______.
window
To minimize the current window, you would use the shortcut Ctrl+F______.
To minimize the current window, you would use the shortcut Ctrl+F______.
9
Pressing Alt+Enter allows you to move to the next ______ while typing text in a cell.
Pressing Alt+Enter allows you to move to the next ______ while typing text in a cell.
line
Using Ctrl+1 allows you to change the ______ of the selected cells.
Using Ctrl+1 allows you to change the ______ of the selected cells.
Signup and view all the answers
The shortcut Ctrl+Shift+& is used to place a ______ around selected cells.
The shortcut Ctrl+Shift+& is used to place a ______ around selected cells.
Signup and view all the answers
To create a formula that sums all of the above cells, you would press Alt+______.
To create a formula that sums all of the above cells, you would press Alt+______.
Signup and view all the answers
To exit Excel, simply use the Alt+F______ shortcut.
To exit Excel, simply use the Alt+F______ shortcut.
Signup and view all the answers
The ______ shortcut allows you to spell check the selected text or document.
The ______ shortcut allows you to spell check the selected text or document.
Signup and view all the answers
To make a cell bold, you would use the Ctrl+______ shortcut.
To make a cell bold, you would use the Ctrl+______ shortcut.
Signup and view all the answers
Ctrl+Shift+F6 moves to the ______ worksheet window.
Ctrl+Shift+F6 moves to the ______ worksheet window.
Signup and view all the answers
To insert a new worksheet, you can use the Alt+Shift+F______ shortcut.
To insert a new worksheet, you can use the Alt+Shift+F______ shortcut.
Signup and view all the answers
You can fill down by selecting a cell and pressing Ctrl+______.
You can fill down by selecting a cell and pressing Ctrl+______.
Signup and view all the answers
With Ctrl+Shift+$, you can apply ______ formatting to your cells.
With Ctrl+Shift+$, you can apply ______ formatting to your cells.
Signup and view all the answers
To insert a hyperlink, you can use the Ctrl+______ shortcut.
To insert a hyperlink, you can use the Ctrl+______ shortcut.
Signup and view all the answers
Pressing F2 allows you to ______ the selected cell.
Pressing F2 allows you to ______ the selected cell.
Signup and view all the answers
The shortcut that cycles through applications is ______.
The shortcut that cycles through applications is ______.
Signup and view all the answers
Signup and view all the answers
Study Notes
Keyboard Shortcuts in Excel
- Ctrl+F4: Closes the current window.
- Ctrl+F5: Restores the window size.
- Ctrl+F6: Navigates to the next workbook.
- Ctrl+Shift+F6: Navigates to the previous workbook.
- Ctrl+F7: Moves the window.
- Ctrl+F8: Resizes the window.
- Ctrl+F9: Minimizes the current window.
- Ctrl+F10: Maximizes the currently selected window.
- Ctrl+F11: Inserts a macro sheet.
- Ctrl+F12: Opens a file.
- Ctrl+Shift+F3: Creates names using row or column labels.
- Ctrl+Shift+F6: Moves to the prior worksheet window.
- Ctrl+Shift+F12: Prints the current worksheet.
- Alt+F1: Inserts a chart.
- Alt+F2: Saves As option.
- Alt+F4: Exits Excel.
- Alt+F8: Opens the macro dialog box.
- Alt+F11: Opens the Visual Basic Editor.
- Alt+Shift+F1: Creates a new worksheet.
- Alt+Shift+F2: Saves the current worksheet.
Formatting Shortcuts
- Ctrl+1: Changes the format of selected cells.
- Ctrl+2: Bold formatting for selected cells.
- Ctrl+3: Applies italic formatting.
- Ctrl+4: Applies underline formatting.
- Ctrl+5: Applies strikethrough formatting.
- Ctrl+6: Shows/hides objects.
- Ctrl+7: Shows/hides the toolbar.
- Ctrl+8: Toggles outline symbols.
- Ctrl+9: Hides rows.
- Ctrl+0: Hides columns.
- Ctrl+Shift+: : Enters the current time.
- Ctrl+; : Enters the current date.
- Ctrl+`: Switches between cell values and formulas.
- Ctrl+' Copies the formula from the cell above.
- Ctrl+Shift+" Copies the value from the cell above.
- Ctrl+-: Deletes the selected column or row.
- Ctrl+Shift+=: Inserts a new column or row.
- Ctrl+Shift+~: Switches between showing Excel formulas or their values.
- Ctrl+Shift+@: Applies time formatting.
- Ctrl+Shift+!: Applies comma formatting.
- Ctrl+Shift+$: Applies currency formatting.
- Ctrl+Shift+#: Applies date formatting.
- Ctrl+Shift+%: Applies percentage formatting.
- Ctrl+Shift+^: Applies exponential formatting.
- Ctrl+Shift+*: Selects the current region around active cell.
- Ctrl+Shift+&: Places borders around selected cells.
- Ctrl+Shift+_ : Removes borders.
- Ctrl++: Inserts.
- Ctrl+-: Deletes.
- Ctrl+Shift+( : Unhides rows.
- Ctrl+Shift+): Unhides columns.
Navigation and Editing Shortcuts
- Shift+Left Arrow: Extends highlighted area to the left.
- Shift+Right Arrow: Extends highlighted area to the right.
- Alt+Tab: Cycles through applications.
- Alt+Spacebar: Opens the system menu.
- Alt+Backspace: Undoes the last action.
- Alt+Enter: Allows multiple lines of text in a cell.
- Alt+=: Creates a formula to sum all above cells.
- F1: Opens the help menu.
- F2: Edits the selected cell.
- F3: Pastes names after creation.
- F4: Repeats last action.
- F5: Goes to a specific cell.
- F6: Moves to the next pane.
- F7: Spell checks selected text/document.
- F8: Enters Extend Mode.
- F9: Recalculates the entire workbook.
- F10: Activates the Menu Bar.
- F11: Creates a chart.
- F12: Saves As.
- Shift+F1: Opens the "What's This? help window".
- Shift+F2: Allows the user to edit a cell comment.
- Shift+F3: Opens the Excel formula window.
- Shift+F5: Brings up a search box.
- Shift+F6: Moves to the previous pane.
- Shift+F8: Adds to the selection.
- Shift+F9: Performs a calculation on the active sheet.
- Ctrl+F3: Opens the Excel Name Manager.
General Shortcuts
- Tab: Moves to the next cell to the right.
- Ctrl+A: Selects all contents of a worksheet.
- Ctrl+B: Bold selects all contents in highlighted area.
- Ctrl+C: Copies highlighted cells.
- Ctrl+D: Fills cells below with contents of the selected cell.
- Ctrl+F: Searches the current sheet.
- Ctrl+G: Goes to a specific area.
- Ctrl+H: Finds and replaces text.
- Ctrl+I: Italicizes highlighted cells.
- Ctrl+K: Inserts a hyperlink.
- Ctrl+N: Creates a new workbook.
- Ctrl+O: Opens a workbook.
- Ctrl+P: Prints the current worksheet.
- Ctrl+R: Fills cells to the right with contents of selected cell.
- Ctrl+S: Saves the current worksheet.
- Ctrl+U: Underlines highlighted cells.
- Ctrl+V: Pastes contents from clipboard.
- Ctrl+W: Closes the current workbook.
- Ctrl+X: Cuts highlighted cells.
- Ctrl+Y: Repeats the last action.
- Ctrl+Z: Undoes the last action.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
