Tracing Dependents

Contact Us or call 1-877-932-8228
Tracing Dependents

Tracing Dependents

Tracing dependents in Microsoft Excel allows you to visually see which cells are impacted by a given cell. To trace dependents:

  1. Select the cell to trace dependents for.
  2. On the FORMULAS tab, in the Formula Auditing group, click the Trace Dependents command:Trace Dependents
  3. The following screen shot shows the dependents for cell C3:Dependents for Cell
  4. By clicking Trace Dependents a second time, we see another level of dependents (the dependents for the cells directly dependent upon the first cell):Trace Dependents
  5. As with precedents, clicking Trace Dependents subsequent times shows additional levels of dependents. If one of the dependent cells is on another sheet, Excel will add an arrow pointing to an image of another sheet.
  6. To remove the arrows showing dependents, click Remove Arrows:Remove Arrows
Next