Microsoft Office Tutorials and References
In Depth Information
precedents and dependents
When you create a formula, Excel evaluates all the
values in the formula and returns the result. If Excel
cannot calculate the formula, it displays an error in
the formula’s cell. You can use the Excel trace
features to help you locate your error.
You can view a graphical representation of the cells
a formula refers to by clicking in the cell and then
clicking Trace Precedents in the Formula Auditing
group on the Formulas tab. This option draws blue
arrows to each cell referenced by your formula. By
selecting this option, you can identify the exact cells
used by your formula.
If you want to find out which formulas use a specific
cell, you can view a graphical representation by
clicking in the cell and then clicking Trace
Dependents in the Formula Auditing group on the
Formulas tab. This option draws blue arrows to each
cell that contains a formula that uses the active cell
as an argument. If you perform this function before
deleting a value, you can determine if your deletion
affects a formula in your worksheet.
T RACE P RECEDENTS
1 Click in the cell containing the
formula for which you want to
l If the cell has an error, an Error
button displays next to the
Click the Formulas tab.
Click Trace Precedents in the
Formula Auditing group.
l Excel draws arrows between the
cells on which the formula is
based and the formula’s cell.
Make the appropriate
modifications to correct the error
in the formula.
Click Remove Arrows.
Excel removes the arrows.
Note: Click the down arrow next to
Remove Arrows to choose Remove
Arrow, Remove Precedent Arrows,
or Remove Dependent Arrows.