Excel Guides

Accessing Dependent and Precedent Information in Excel

There are a few ways to access dependent and precedent information in Excel. One way is to use the Trace Precedents and Trace Dependents features. To do this, first select the cell you want to trace precedents or dependencies for. Then, go to the Formulas tab on the ribbon and click the Trace Precedents or Trace Dependents button, depending on which you want to do. This will show arrows pointing from the selected cell to all of its dependent or precedent cells.

Another way to find precedent and dependent cells is to use the Go To feature. To do this, go to the Home tab on the ribbon and click the Find & Select button. Then, click Go To. In the Go To dialog box that appears, click the Special button. This will open the Go To Special dialog box. In this dialog box, you can choose to look for cells that are precedents or dependents of the selected cell by selecting the appropriate option from the drop-down list.

Once you've found all of the precedent or dependent cells, you can then do whatever you want with that information. For example, you could highlight all of those cells so that they're easy to find, or you could delete them if they're no longer needed.

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.