Tracing dependents in Microsoft Excel allows you to visually see which cells are impacted by a given cell. To trace dependents:
Select the cell to trace dependents for.
On the FORMULAS tab, in the Formula Auditing group, click the Trace Dependents command:
The following screen shot shows the dependents for cell C3:
By clicking Trace Dependents a second time, we see another level of dependents (the dependents for the cells directly dependent upon the first cell):
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.
To remove the arrows showing dependents, click Remove Arrows: