|
|||
This versatile tool allows you to navigate between the cells which originate and/or depend on a cell under observation. This works even through sheets contained in other workbooks. In addition to this, a series of tools are included to allow movement and viewing cells, such as:
Let us see an example: |
|||
The first time the tool is activated, if the active cell has a formula, by default, the tool will detect the origins of the cell. But, each time we wish to analyze a cell, we must again go over the following steps: Thus, the tool will detect the originating or dependent cells of the selected cell, and the dialogue box will unfold a list of such cells. In addition, we can select the resulting cells or maybe add color to them so they can be easily distinguished. |
|||
In order to evaluate the result of a section from your formula: | |||
1. First select a segment of your formula according as it is shown in the image. | |||
2. Then press button evaluate. | |||
3. Place the cursor on the text box corresponding to the Editor formula. | |||
Note: | |||
Undo button will only bring back the last time the formula has been overwriten | |||