Show and evaluate formulas
Quickly show and evaluate formulas, find inconsistent formulas and troubleshoot them quickly.
Show formulas quickly with the keyboard
Trouble with functions? Not sure which cells are formulas? Need help remembering which arguments each function needs? Then this tip is for you!
To quickly show formulas, just use this keyboard shortcut:
Keyboard shortcut to show formulas in Excel
Use this keyboard shortcut to quickly toggle between showing formulas and normal cell contents:
|Toggle between showing formulas and normal cell contents||Ctrl + `|
The ` key is to the left of the 1 on the main keyboard, sometimes called the tilde (~) key.
Displaying formulas can give you a quick way to see how a worksheet’s formulas are set up, including:
- See which cells use formulas or which are input directly;
- Find formulas that are inconsistent with other formulas in the surrounding cells;
- Quickly spot “hard-coded” direct inputs or overrides hiding amongst formulas.
When displaying formulas, column widths are shown at double their normal width. This is to give you more chance of seeing the whole formula. Depending on the length of your formulas, you may need to widen them further.
Don’t have a login?
Get a login for free on our standard plan, and get a new tip each week.
All logins also get access to the bonus tip each week.
Get even more
Get even more with one of our reasonably priced paid plans, with access to features like:
- Quicksheet PDF summaries
- Example files
- VBA syntax
- Additional expert tips each week
- Advance publication