Showing formulas instead of results

<< Click to Display Table of Contents >>

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 show_formulas_icon (in the group View).

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