Questions and Answers
What happens when you press CTRL+A in Excel?
What is the function of CTRL+SHIFT+L in Excel?
What is the shortcut to copy the contents and format of the topmost cell of a selected range into the cells below?
What is the function of CTRL+; in Excel?
Signup and view all the answers
What is the function of CTRL+~ in Excel?
Signup and view all the answers
What is the function of CTRL+1 in Excel?
Signup and view all the answers
What is the function of CTRL+6 in Excel?
Signup and view all the answers
What is the function of CTRL+C followed by another CTRL+C in Excel?
Signup and view all the answers
What does pressing F6 do in Excel?
Signup and view all the answers
What does pressing SHIFT+F6 do in Excel?
Signup and view all the answers
What does pressing CTRL+F6 do in Excel?
Signup and view all the answers
What does pressing F7 do in Excel?
Signup and view all the answers
What does pressing CTRL+F7 do in Excel?
Signup and view all the answers
What does pressing F8 do in Excel?
Signup and view all the answers
What does pressing SHIFT+F8 do in Excel?
Signup and view all the answers
What does pressing F9 do in Excel?
Signup and view all the answers
What is the shortcut to access the Visual Basic Window?
Signup and view all the answers
Which shortcut is used to record a macro in Excel?
Signup and view all the answers
What is the shortcut to access the 'More Controls' option within Active X Controls?
Signup and view all the answers
Which shortcut is used to enter Design Mode in Excel?
Signup and view all the answers
What is the shortcut to access the 'Properties' window in Excel?
Signup and view all the answers
Which shortcut is used to view the source code of a selected object in Excel?
Signup and view all the answers
What is the shortcut to access the 'Run Dialog' in Excel?
Signup and view all the answers
Which shortcut allows you to move to the next cell in a worksheet?
Signup and view all the answers
What does the shortcut ALT+SHIFT+F10 do?
Signup and view all the answers
Which shortcut would you use to create a chart of the current data range?
Signup and view all the answers
What is the function of the shortcut ALT+I+C?
Signup and view all the answers
What does pressing ALT+F+O+K do?
Signup and view all the answers
Which shortcut is used to increase font size quickly?
Signup and view all the answers
To access the Visual Basic Editor, which shortcut should you use?
Signup and view all the answers
What does ALT+N+V enable the user to do?
Signup and view all the answers
Which shortcut will toggle between showing all or limited properties?
Signup and view all the answers
Which shortcut is utilized for Autosum?
Signup and view all the answers
What does ALT+F+E+C+D+A accomplish?
Signup and view all the answers
What does the CTRL+PAGE DOWN shortcut do?
Signup and view all the answers
Which shortcut selects the entire row in a worksheet?
Signup and view all the answers
What action does pressing the SPACEBAR in a dialog box perform?
Signup and view all the answers
When is CTRL+SHIFT+SPACEBAR used to select the entire worksheet?
Signup and view all the answers
Which shortcut moves one screen up in a worksheet?
Signup and view all the answers
What does the SHIFT+TAB shortcut do?
Signup and view all the answers
Which of the following shortcuts selects the current and next sheets in a workbook?
Signup and view all the answers
What does the ALT+SPACEBAR shortcut display?
Signup and view all the answers
Study Notes
Excel Shortcuts
- Delete rows/columns: If entire row(s) / column(s) is selected, it deletes them.
- Filtering: CTRL+SHIFT+L applies/removes filter.
- Date entry: CTRL+; enters the current date.
- Formula display: CTRL+~ alternates between displaying cell values and displaying formulas in the worksheet.
- Copy formula: CTRL+' copies a formula from the cell above the active cell into the cell or the Formula Bar.
Formatting
- Format cells: CTRL+1 displays the Format Cells dialog box.
- Bold formatting: CTRL+2 applies or removes bold formatting.
- Italic formatting: CTRL+3 applies or removes italic formatting.
- Underlining: CTRL+4 applies or removes underlining.
- Strikethrough: CTRL+5 applies or removes strikethrough.
Object manipulation
- Object display: CTRL+6 alternates between hiding objects, displaying objects, and displaying placeholders for objects.
- Outline symbols: CTRL+8 displays or hides the outline symbols.
- Row/Column hiding: CTRL+9 hides the selected rows, CTRL+0 hides the selected columns.
Worksheet selection
- Select entire worksheet: CTRL+A selects the entire worksheet.
- Select current region: When the worksheet contains data, CTRL+A selects the current region.
- Select summary rows: Pressing CTRL+A a second time selects the current region and its summary rows.
- Select entire worksheet (again): Pressing CTRL+A a third time selects the entire worksheet.
Function arguments
- Function Arguments dialog box: When the insertion point is to the right of a function name in a formula, displays the Function Arguments dialog box.
- Argument names and parentheses: CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is to the right of a function name in a formula.
Copy, Fill, and Clipboard
- Copy cells: CTRL+C copies the selected cells.
- Clipboard display: CTRL+C followed by another CTRL+C displays the Clipboard.
- Fill Down command: CTRL+D uses the Fill Down command to copy the contents and format of the topmost cell of a selected range into the cells below.
- Refresh links: CTRL+ALT+F5 refreshes all links.
Navigation and management
- Switch between panes: F6 switches between the worksheet, Ribbon, task pane, and Zoom controls.
- Split panes: In a worksheet that has been split, F6 includes the split panes when switching between panes and the Ribbon area.
- Next workbook window: CTRL+F6 switches to the next workbook window when more than one workbook window is open.
- Spelling dialog box: F7 displays the Spelling dialog box to check spelling in the active worksheet or selected range.
- Move command: F7 performs the Move command on the workbook window when it is not maximized.
- Extend mode: F8 turns extend mode on or off.
- Nonadjacent cell selection: SHIFT+F8 enables you to add a nonadjacent cell or range to a selection of cells by using the arrow keys.
- Macro dialog box: ALT+F8 displays the Macro dialog box to create, run, edit, or delete a macro.
Calculation and recalculation
- Calculate all worksheets: F9 calculates all worksheets in all open workbooks.
- Calculate active worksheet: SHIFT+F9 calculates the active worksheet.
- Calculate all worksheets (regardless of changes): CTRL+ALT+F9 calculates all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
- Recheck dependent formulas and calculate: CTRL+ALT+SHIFT+F9 rechecks dependent formulas, and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Miscellaneous
- Minimize workbook window: F9 minimizes a workbook window to an icon.
- Key tips: F10 turns key tips on or off.
- Shortcut menu: SHIFT+F10 displays the shortcut menu for a selected item.Here are the study notes for the text:
- ALT Keys for Excel*
-
File Tab ALT Keys
- ALT+F: Displays Backstage view
- ALT+F+N: Creates a new workbook
- ALT+F+O: Opens an existing workbook
- ALT+F+S: Saves the workbook
- ALT+F+P: Prints the workbook
- ... (more options)
-
Home Tab ALT Keys
- ALT+H: Goes to Home tab
- ALT+H+X: Cuts
- ALT+H+C: Copies
- ALT+H+F+P: Format Painter
- ... (more options)
-
Insert Tab ALT Keys
- ALT+N: Inserts a### Switch Windows
- ALT+W+M+V: View Macros
- ALT+W+M+R: Record Macros
- ALT+W+M+U: Use Relative References
Developer Tab Shortcuts
- ALT+L+V: Visual Basic Window
- ALT+L+P+M: Macros Window
- ALT+L+R: Record Macro
- ALT+L+U: Use Relative Reference
- ALT+L+A+S: Macro Security
- ALT+L+H: Add-ins
- ALT+L+J: COM Add-ins
Form Controls and Active X Controls
- ALT+L+I+B: Form Controls > Button
- ALT+L+I+C: Form Controls > Combo Box
- ALT+L+I+H: Form Controls > Check Box
- ALT+L+I+S: Form Controls > Spin Button
- ALT+L+I+I: Form Controls > List Box
- ALT+L+I+P: Form Controls > Option Button
- ALT+L+I+G: Form Controls > Group Box
- ALT+L+I+L: Form Controls > Label
- ALT+L+I+S: Form Controls > Scroll Bar
- ALT+L+I+B: Active X Controls > Button
- ALT+L+I+L: Active X Controls > List Box
- ALT+L+I+T: Active X Controls > Text Box
- ALT+L+I+S: Active X Controls > Scroll Bar
- ALT+L+I+N: Active X Controls > Spin Button
- ALT+L+I+O: Active X Controls > Option Button
- ALT+L+I+A: Active X Controls > Label
- ALT+L+I+I: Active X Controls > Image
- ALT+L+I+G: Active X Controls > Toggle Buttons
- ALT+L+I+M: Active X Controls > More Controls
Other Shortcuts
- ARROW: Move one cell up, down, left, or right in a worksheet
- PAGE DOWN: Moves one screen down in a worksheet
- ALT+PAGE DOWN: Moves one screen to the right in a worksheet
- CTRL+PAGE DOWN: Moves to the next sheet in a workbook
- CTRL+SHIFT+PAGE DOWN: Selects the current and next sheet in a workbook
- PAGE UP: Moves one screen up in a worksheet
- ALT+PAGE UP: Moves one screen to the left in a worksheet
- CTRL+PAGE UP: Moves to the previous sheet in a workbook
- CTRL+SHIFT+PAGE UP: Selects the current and previous sheet in a workbook
- SPACEBAR: In a dialog box, performs the action for the selected button, or selects or clears a check box
- CTRL+SPACEBAR: Selects an entire column in a worksheet
- SHIFT+SPACEBAR: Selects an entire row in a worksheet
- CTRL+SHIFT+SPACEBAR: Selects the entire worksheet
- ALT+SPACEBAR: Displays the Control menu for the Microsoft Office Excel window
- TAB: Moves one cell to the right in a worksheet
- SHIFT+TAB: Moves to the previous cell in a worksheet or the previous option in a dialog box
- CTRL+TAB: Switches to the next tab in dialog box
- CTRL+SHIFT+TAB: Switches to the previous tab in a dialog box
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
This quiz covers essential shortcuts in Microsoft Excel, improving productivity and efficiency in worksheet management. Learn Ctrl+ shortcuts for deleting rows, applying filters, and formatting cells.
