See Formulas on an Excel Worksheet

Last week I was testing a client’s workbook, and had filled in all the data entry cells, to make sure everything was working correctly.
Before sending the workbook back to my client, I wanted to clear all the data entry cells. Instead of selecting each cell individually, and clearing it, it would be easier to clear groups of adjacent cells where possible.
However, some cells had formulas, and I didn’t want to accidentally clear any of those. If the formulas are visible, that would prevent the problem.

To see the formulas in Excel 2003:

  • On the Tools menu, click Options
  • On the View tab, add a check mark to Formulas.


To see the formulas in Excel 2007

Click the Office button, then click Excel Options
Click the Advanced category
In the Display Options for This Worksheet section, add a check mark to Show formulas in cells instead of their calculated results.

Show or Hide Formulas with a Keyboard Shortcut

The keyboard shortcut to show or hide the formulas is Ctrl +   (accent grave, which may be above the Tab key on the keyboard)