Microsoft Office Tutorials and References
In Depth Information
To help follow and fix formulas, Excel provides formula auditing tools. The
Ribbon’s Formula Auditing section of the Formulas tab has three buttons that
let you use formula auditing. Figure 4-14 shows the worksheet from Figure 4-13
with visible precedent and dependent lines. The methods for displaying these
lines are shown in the Ribbon.
Precedent and Dependent lines are always inserted from or to the active cell.
From the active cell:
✓ To see what other cells are referenced in the active cell’s formula, click
the Trace Precedents button.
✓ To see which other cells contain a reference to the active cell, click the
Trace Dependents button.
The Remove Arrows drop-down has three choices:
✓ Remove Arrows
✓ Remove Precedent Arrows
✓ Remove Dependent Arrows
In Figure 4-14, cells B9 and F9 have arrows that originate in the cells above.
This shows the flow of precedents into the given cells. The arrow head rests
in the cell that has the formula that contains the references of the precedents.
On the other hand, cells B9 and F9 themselves then have lines coming from
them and ending as arrow heads in cell B18. Therefore, B9 and F9 serve as
precedents to cell B18. Or, said another way, cell B18 is dependent on cells
B9 and F9.