Toggle the display of formulas on a sheet in Excel
/When working in Excel, you may wish to see the formulas in use on your worksheet to help you track down an error, or to see which cells are dependent upon other cells.
To toggle the display of formulas on a sheet:
Excel displays the formulas contained in cells on the active worksheet; it displays the underlying serial numbers for dates, and opens the Formula Auditing toolbar.
Excel spreadsheet with formulas displayed
Note: Alternatively, you can toggle the display of formulas in Excel by pressing CTRL + ` (grave accent).
To toggle the display of formulas on a sheet:
- In the Tools menu, click Options.
- On the View tab, in the Windows options area, check Formulas.
- Click OK.

Excel displays the formulas contained in cells on the active worksheet; it displays the underlying serial numbers for dates, and opens the Formula Auditing toolbar.

Note: Alternatively, you can toggle the display of formulas in Excel by pressing CTRL + ` (grave accent).