Keyboard Shortcuts

Question 1

1. What is the keyboard shortcut to show all formulas?
2. What are some other ways to quickly show or find formulas?

Answer 1

1. Ctrl + `
2. *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

Question 2

What is the keyboard shortcut to take you to cell A1?

Answer 2

Ctrl + Home

Question 3

What is the method + keyboard shortcut to quickly select an entire rectangle or table of contiguous data?

Answer 3

1. Click on a cell that has data
2. Ctrl + A

Question 4

What are the two keyboard shortcuts used to quickly jump to all 4 corner edges of a table?

Answer 4

1. Click on a cell with data
2. Ctrl + A
3. Ctrl + .

Question 5

1. What keyboard shortcut only selects the currently visible (or selected) cells?
2. Why would you need or want to do this?
3. When would you not need to do this?

Answer 5

1. Alt + ;
2. If you only want to copy one level of data from Subtotals as part of an Outline
3. 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.

Question 6

What keyboard shortcut invokes Flash Fill?

Answer 6

Ctrl + E

Question 7

What keyboard shortcut refreshes the data in the PivotTable cache?

Answer 7

Alt + F5

Question 8

What is the keyboard shortcut for Print Preview?

Answer 8

Ctrl + F2

Question 9

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)

Answer 9

Ctrl + 8

Note - in order to use this keyboard shortcut, you must first have a Subtotal or an Outline applied to the data.

Question 10

What is the method + keyboard shortcut for quickly copying a Worksheet tab?

Answer 10

1. Select a Worksheet tab
2. Ctrl + mouse drag

Question 11

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)?

Answer 11

Ctrl + 8

Question 12

What is the keyboard shortcut that allows you to quickly switch between multiple Excel Workbooks (files)?

Answer 12

Ctrl + Tab

or

Ctrl + Shift + Tab

Question 13

What is the keyboard shortcut that will allow you to add line breaks to a formula (to make it easier to read or understand)?

Answer 13

Alt + Enter

Question 14

How do you quickly jump into the formula bar to edit the contents of a cell?

Answer 14

F2

Question 15

1. What is the keyboard shortcut for adding a line break (return) within a cell?
2. Why can this be particularly useful for formulas?

Answer 15

1. Alt + Enter when your mouse is selected within a cell
2. It can make long or nested formulas easier to understand and read by putting different statements on different rows

Question 16

What is the name of the feature that allows you to quickly arrange and resize multiple active Excel workbooks?

Answer 16

Arrange All

Question 17

1. What is the best way external / broken links in Excel?
2. What is the most likely culprit?
3. What are the steps to execute this search?

Answer 17

1. Use the Compatibility Checker
2. Data Validation Errors that were copied into Data Validation cells from other worksheets that no longer exist
3. 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

Question 18

What are are the two keyboard shortcuts to quickly cycle between worksheets?

Answer 18

1. Ctrl + Page Up
2. Ctrl + Page Down