Trace Worksheet Relationships : Formula Trace « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Formula Trace

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.

6.10.Formula Trace
	6.10.1.	Trace Worksheet Relationships