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