If you're anything like me, you're always looking for ways to work smarter, not harder. That's why I'm excited to share with you my favorite shortcut for quickly viewing formulas in Excel. This simple tip can save you time and frustration when trying to troubleshoot errors in your formulas or understand how a complex worksheet was created.
To view formulas in Excel, simply press the Ctrl + ` keys (i.e. the grave accent key, typically located above the Tab key). Doing so will instantly display all formulas in your worksheet, rather than their resulting values. Formulas will appear in their cell as well as in the formula bar above.
If you only want to view formulas for a specific cell or range of cells, simply select those cells before pressing Ctrl + `. To return to the normal view, press Ctrl + ` again or press the Esc key.
This shortcut is an absolute lifesaver when trying to debug errors in your formulas. No more guessing which cells contain formulas and which don't!
Do you have a favorite Excel shortcut? Share it in the comments below.