|
||||
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 | ||||