Excel Guides

Tracing Dependent Cells in Excel

There are a few different ways that you can trace dependent cells in Excel. One way is to use the built-in Trace Dependents feature. To do this, first select the cell that you want to trace the dependents for. Then, go to the Formulas tab and click on the Trace Dependents button. This will show you all of the cells that are dependent on the selected cell.

Another way to trace dependents is to use a macro. There are a few different macros that you can use, but we'll just show one example here. To use this macro, first select the cell that you want to find the dependents for. Then, run the following macro:

Sub FindDependents()
 Dim c As Range
 For Each c In Selection.Cells
  If Not IsEmpty(c) Then
   Debug.Print c.Address & ": " & _
     Join(Application.InputBox _
       (Prompt:="Select cells", Type:=8), ", ")
  End If
 Next c
End Sub

This macro will prompt you to select the cells that are dependent on the selected cell. Simply select the cells and click OK. The macro will then print out the addresses of all of the selected cells.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.