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:

  1. In the Tools menu, click Options.

  2. On the View tab, in the Windows options area, check Formulas.

    3. Excel Options Dialog box Excel Options Dialog box
  3. 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.

Excel spreadsheet with formulas displayed Excel spreadsheet with formulas displayed

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