How to Show Formulas in Excel

Sometimes you need to see the logic, not the numbers. Switching a sheet to show formulas reveals exactly what every cell is doing, which is the fastest way to spot hardcodes, inconsistent rows, and broken references. Here is how to toggle it and what to do once it is on.

Toggle Show Formulas with the keyboard

The quickest way is a single shortcut that flips the active sheet between values and formulas.

1. Click any cell on the sheet you want to inspect.
2. Press Ctrl plus the grave accent key, using the grave accent key above Tab on most keyboards.
3. Every cell now displays its formula, and columns widen to fit.
4. Press Ctrl plus the grave accent key again to switch back to normal values.

Use the Show Formulas button

If you prefer the ribbon, go to the Formulas tab and click Show Formulas in the Formula Auditing group. It is the same toggle as the shortcut. Note that Show Formulas applies per worksheet, so turning it on for one tab does not affect the others.

Print or compare the formula view

With formulas showing, you can print the sheet to get a paper map of its logic, useful in a review meeting. You can also widen columns and screenshot a block to compare two versions of a model side by side without opening each cell.

What to look for once formulas are visible

Showing formulas is most powerful as a scanning tool. Read across each row and check that the formula is identical between periods, watch for numbers typed directly into formulas, and look for references pointing at the wrong cell or a deleted range that now reads #REF!.

Go from showing to walking with ModelMint

Show Formulas reveals the logic on one sheet, but it cannot follow a reference into another tab. When you spot a formula worth chasing, ModelMint Formula Trace lets you step through its precedents one layer at a time with the arrow keys, across the whole workbook, with each reference highlighted live in the formula bar.