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.
The shortcut Ctrl+Shift+& is used to place a ______ around selected cells.
The shortcut Ctrl+Shift+& is used to place a ______ around selected cells.
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+______.
To exit Excel, simply use the Alt+F______ shortcut.
To exit Excel, simply use the Alt+F______ shortcut.
The ______ shortcut allows you to spell check the selected text or document.
The ______ shortcut allows you to spell check the selected text or document.
To make a cell bold, you would use the Ctrl+______ shortcut.
To make a cell bold, you would use the Ctrl+______ shortcut.
Ctrl+Shift+F6 moves to the ______ worksheet window.
Ctrl+Shift+F6 moves to the ______ worksheet window.
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.
You can fill down by selecting a cell and pressing Ctrl+______.
You can fill down by selecting a cell and pressing Ctrl+______.
With Ctrl+Shift+$, you can apply ______ formatting to your cells.
With Ctrl+Shift+$, you can apply ______ formatting to your cells.
To insert a hyperlink, you can use the Ctrl+______ shortcut.
To insert a hyperlink, you can use the Ctrl+______ shortcut.
Pressing F2 allows you to ______ the selected cell.
Pressing F2 allows you to ______ the selected cell.
The shortcut that cycles through applications is ______.
The shortcut that cycles through applications is ______.
Flashcards
Shift + Left Arrow
Shift + Left Arrow
Extends the highlighted area one character to the left.
Shift + Right Arrow
Shift + Right Arrow
Extends the highlighted area one character to the right.
Alt + Tab
Alt + Tab
Cycles through open applications.
Alt + Spacebar
Alt + Spacebar
Signup and view all the flashcards
Alt + Backspace
Alt + Backspace
Signup and view all the flashcards
Ctrl + A
Ctrl + A
Signup and view all the flashcards
Ctrl + C
Ctrl + C
Signup and view all the flashcards
Ctrl + D
Ctrl + D
Signup and view all the flashcards
Close Current Window
Close Current Window
Signup and view all the flashcards
Restore Window Size
Restore Window Size
Signup and view all the flashcards
Next Workbook
Next Workbook
Signup and view all the flashcards
Previous Workbook
Previous Workbook
Signup and view all the flashcards
Bold Text
Bold Text
Signup and view all the flashcards
Italics Text
Italics Text
Signup and view all the flashcards
Underline Text
Underline Text
Signup and view all the flashcards
Strikethrough Text
Strikethrough Text
Signup and view all the flashcards
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.
