Analyzing sheets |
  
|
Analyzing sheets |
|
Calculate provides several tools for analyzing cell contents and formulas in a worksheet. They can be very useful for troubleshooting.
For this purpose, the following tools are available:
▪Showing formulas instead of results
| If you choose the ribbon command View | Show formulas, cells containing a calculation will display the formula rather than the result. |
| If you choose the ribbon command View | Syntax highlighting, cells will be color-coded according to their content. For example, cells containing an error are displayed in red; cells containing a formula are displayed in green, etc. |
For more information on these functions, see the following pages.