Keyboard Shortcuts Flashcards
- What is the keyboard shortcut to show all formulas?
- What are some other ways to quickly show or find formulas?
- Ctrl + `
- *There is also a Show Formulas button on the Formulas ribbon tab.
*You can also use the Find & Select > Formulas option to highlight all the cells containing a formula on a worksheet quickly
What is the keyboard shortcut to take you to cell A1?
Ctrl + Home
What is the method + keyboard shortcut to quickly select an entire rectangle or table of contiguous data?
- Click on a cell that has data
- Ctrl + A
What are the two keyboard shortcuts used to quickly jump to all 4 corner edges of a table?
- Click on a cell with data
- Ctrl + A
- Ctrl + .
- What keyboard shortcut only selects the currently visible (or selected) cells?
- Why would you need or want to do this?
- When would you not need to do this?
- Alt + ;
- If you only want to copy one level of data from Subtotals as part of an Outline
- By default, using Filters only copies the currently visible data, so you wouldn’t need this keyboard shortcut when copying data from a filtered selection.
What keyboard shortcut invokes Flash Fill?
Ctrl + E
What keyboard shortcut refreshes the data in the PivotTable cache?
Alt + F5
What is the keyboard shortcut for Print Preview?
Ctrl + F2
What is the keyboard shortcut to quickly hide or unhide the data Grouping number symbols that exist to the left and above cells in a worksheet?
Note: Grouping is used either when creating Subtotals or Outlines (think Balance Sheet)
Ctrl + 8
Note - in order to use this keyboard shortcut, you must first have a Subtotal or an Outline applied to the data.
What is the method + keyboard shortcut for quickly copying a Worksheet tab?
- Select a Worksheet tab
- Ctrl + mouse drag
What is the keyboard shortcut to automatically hide or unhide data Grouping symbols that exist above and to the left of cells (when your data is Grouped)?
Ctrl + 8
What is the keyboard shortcut that allows you to quickly switch between multiple Excel Workbooks (files)?
Ctrl + Tab
or
Ctrl + Shift + Tab
What is the keyboard shortcut that will allow you to add line breaks to a formula (to make it easier to read or understand)?
Alt + Enter
How do you quickly jump into the formula bar to edit the contents of a cell?
F2
- What is the keyboard shortcut for adding a line break (return) within a cell?
- Why can this be particularly useful for formulas?
- Alt + Enter when your mouse is selected within a cell
- It can make long or nested formulas easier to understand and read by putting different statements on different rows
What is the name of the feature that allows you to quickly arrange and resize multiple active Excel workbooks?
Arrange All
- What is the best way external / broken links in Excel?
- What is the most likely culprit?
- What are the steps to execute this search?
- Use the Compatibility Checker
- Data Validation Errors that were copied into Data Validation cells from other worksheets that no longer exist
- File tab > Info > Check for Issues > Copy to New Sheet > Ctrtl + F > Search for Data Validation > click each hyperlink to search for external links in the Source field
What are are the two keyboard shortcuts to quickly cycle between worksheets?
- Ctrl + Page Up
- Ctrl + Page Down