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
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
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.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.