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.