Click the Formulas tab. Click the Trace Precedents button to find cells
that provide data to a formula.
Click the Trace Dependents button to find out
which formulas refer to a cell.
Click the Error Checking button arrow, and then
click Trace Error to locate the problem if a formula displays an error value, such as #DIV/0!.
Click Remove Arrows button arrow, and then click Remove Precedent Arrows, or Remove Dependent Arrows, or Remove All Arrows to remove precedent and dependent arrows.
No comments:
Post a Comment