When you’re troubleshooting an Excel worksheet, it may help to see the formulas temporarily, instead of the results. With the formulas visible, you can quickly check that the cell references are correct and the formulas are consistent.
Tip: The keyboard shortcut to show or hide the formulas is Ctrl + ‘ (accent grave, may be above the Tab key on the keyboard).
To view the formulas in Excel 2003:
- On the Tools menu, click Options
- On the View tab, under Windows Options, add a check mark to Formulas.
To view the formulas in Excel 2007:
- On the Ribbon, click the Formulas tab.
- In the Formula Auditing Group, click Show Formulas.