Navigation:  Editing worksheets > Analyzing sheets > Showing formulas instead of results

If you enable Show formulas, cells containing a calculation will display the formula rather than the result. This can be useful when analyzing the formulas in a worksheet and for troubleshooting.

Enabling and disabling "Show formulas"

To enable the "Show formulas" tool, choose the ribbon command View | Show formulas (in the group View).

If you choose this command again, the "Show formulas" tool will be disabled.