Microsoft Office Tutorials and References
In Depth Information
Show Formulas Instead of Results
Chapter 4: Getting More Out of Formulas
The Excel Options dialog
4 Click Advanced.
5 Click to select the Show
Formulas In Cells Instead
of Their Calculated
6 Click OK.
Excel displays the
formulas instead of their
Note: You can also toggle the
display between formulas and
results by pressing Ctrl+`.
The technique you learned in this section applies only to the current worksheet. If you
want to view the formulas in every sheet in a workbook, run the following VBA macro:
Dim win As Window
Dim wv As WorksheetView
For Each win In ActiveWorkbook.Windows
For Each wv In win.SheetViews
wv.DisplayFormulas = Not wv.DisplayFormulas
See Chapter 11 to learn how to add and run a VBA macro in Excel.