|
|
Decompose Formula |
|
|
|
|
Many times we would like to determine the origin of each of the cells forming part of a formula,
including cells in other sheets, numeric values of the formula; and even cells originating from other workbooks.
This tool performs this task.
Let us see an example:
We position ourselves in a cell containing a formula.
We then press the Decompose formula button and the dialogue box will ask for a cell to start unfolding the results. |
|
|
|
After we press the OK button, we will see the following result: |
|
|
|
Results in yellow indicate that these cells belong to the active sheet.
The result in light blue tells us that there is a cell in this formula which originates from a different sheet.
Finally, the result in gray is the original formula which has been again rebuilt in the active sheet.
The colors can be customized; all you need to do is to access the Settings button of this dialog box. |
|
|
|