Displaying formulas instead of results

<< Click to Display Table of Contents >>

Displaying 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 table and for detecting errors.

Enabling and disabling "Show formulas"

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

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