Tracing Dependent Cells

Dependent cells are cells that use the value in the active cell in their formulas

Click the Trace Dependent button on the Formula Auditing toolbar



To determine the dependent cell, double-click the tracer arrow-> Go To dialog box



B14 is dependent on the value in cell B21 in the Balance Sheet worksheet