<< 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 (in the View group).
If you click on this command again, the "Show formulas" tool will be disabled.