|
<< Click to Display Table of Contents >> Analyzing sheets |
PlanMaker 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. |
▪Watch window for cell content
| If you choose the ribbon command Formula | Show watch list, you can display a watch window for cell contents at any time. It allows you to observe the current values in the specified cells. |
| The commands of the ribbon tab Formula | group Traces provide tools for graphically representing the relationships between cells. If, for example, the current cell contains a formula that refers to other cells, you can let PlanMaker display arrows pointing to these cells. |
| Furthermore, errors can be detected in the worksheet or invalid data can be marked with red circles. |
For more information on these functions, see the following pages.