Excel Keyboard Shortcuts for the Everyday User

Who wants to (or has the time) to do anything the long way. We’ve provided some great shortcuts to get your tasks completed with ease and efficiency. 

Display Formulas Instead of Results

Pressing Ctrl+~ allows you to see the formulas instead of their results.

Pressing Ctrl+~ allows you to see the formulas instead of their results.

A single keystroke is all it takes for you to toggle between Excel’s normal display, which shows the results of the formulas in the spreadsheet, and a display mode that shows the actual formulas. The keystroke is Ctrl+tilde (tilde is this key: “~” and is found above the Tab key and to the left of the “1” key). Press Ctrl+~, and Excel displays formulas instead of results. Press it again, and the results appear again.

Build the Sum Function Quickly

Pressing Alt+= inserts the Sum function.

Pressing Alt+= inserts the Sum function.

To create a sum formula without having to type the whole formula out or use the ribbon, hit Alt+= and Excel creates the SUM function including adjacent cells in the formula. 

Highlight all cells referenced by a formula

When you’re trying to fix a worksheet, you can easily navigate through all the cells referenced in a formula. Highlight the cell and press Ctrl+[ (that’s Ctrl+open-square-bracket). Excel highlights all the cells referenced by the formula, and moves the current selection to the first of the referenced cells. Press Enter, and the selection moves to the next referenced cell, and continue to press Enter to move though the rest of the referenced cells. Screenshot examples are shown below.

First step: Select the cell you wish to evaluate.

First step: Select the cell you wish to evaluate.

Second step: Press Ctrl+[ to highlight cells who are involved with your formula.

Second step: Press Ctrl+[ to highlight cells who are involved with your formula.

Highlight the Formulas that Reference the Current Cell

The previous tip explained how to use Ctrl+[ (Ctrl+open-square-bracket) to see all the cells referenced by a formula. What if you want to do the reverse, and see the formulas that reference the cell? Select the cell, and press Ctrl+] (Ctrl+close-square-bracket). As in the previous tip, the selection moves to the first formula that references the cell. Press Enter repeatedly to navigate to the other formulas that reference the cell. Screenshot examples are shown below.

First step: Select the cell you wish to evaluate.

First step: Select the cell you wish to evaluate.

Second step: Press Ctrl+] to highlight the formula that references that cell.

Second step: Press Ctrl+] to highlight the formula that references that cell.

 

This entry was posted in Computer tips, Excel tips, Microsoft Office tips, Uncategorized and tagged , , , , , , , , , . Bookmark the permalink.

Comments are closed.