|
|||
This utility as it´s name indicates, allows us to analize in a specific range, a group of formulas and all the precedence/dependence connections between them. There are two options for this: Auditing arrows: Gridlines: This option will show this type of grid: when it determines that until this cell, a new type of formulas begins. This option will show this type of grid: when it detects that the analized cell have a formula accordant to the creation pattern, similar to the cell on its left side. It will show this type of grid: when it detects that the analized cell have a formula accordant to the creation pattern similar to the cell above it. It will show this type of grid: when it detects that the analized cell does not comply with a formula pattern between the cells that are above, below, at the left or at the right side of it. For example: Select a range with formulas: Select the tool with a click in the correspondent button in the tool box. The next dialog box will appear: |
|||
Before you press the button: ´Doit`, optionally we can change the colors that the tool will use. In this case we have selected the yellow and red colors. |
|||
Opcionally, you will be able to configue the Test and Highlights options to find out and check the option you want. Simply, click on the corresponding check opcion and press Ok. |
|||
After you press the Ok button, we will be again facing the dialog box. |
|||
Observe that because of the grids that the tool made, we can clearly determine that all the columns have a creation pattern similar to the first column. Imagine this is not like this, maybe the grids would allow us to find out an unusual or abnormal situation. |
|||
Note: | |||
If you have run the Do it ! button and then you want to clear the arrows and gridlines, simply press the button "Clear gridlines,arrows and highlights" | |||
The button to clear the gridlines will be visible after pressing the doit button "Do it ! " | |||
The opction : "Change color" for the arrows is not available in Excel 2007 | |||