Tracing Formula Dependents

Use the Trace Dependents button on the Formula Auditing toolbar to trace all the generations of cells that either directly or indirectly utilize the formula in the selected cell (kind of like tracing the genealogy of all your progeny). Tracing dependents with the Trace Dependents button is much like tracing precedents with the Trace Precedents button. Each time you click this button, Excel draws another set of arrows that shows a generation of dependents further removed.

To display both the direct and indirect dependents on the same sheet as the formula, double-click the Trace Dependents button on the Formula Auditing toolbar. Likewise, to remove all the tracer arrows, double-click its Remove Dependent Arrows button.