6.10.1.Trace Worksheet Relationships |
|
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.
|
|
 |