How to Trace Dependents in Excel

Before you change an input, you need to know what it feeds. Tracing dependents shows every formula that reads from the selected cell, so you can see the blast radius of an edit before you make it. Here is how to do it in Excel.

Use the Trace Dependents arrows

The Formula Auditing group has a matching tool for the other direction.

1. Select the cell you are about to change.
2. On the Formulas tab, click Trace Dependents in the Formula Auditing group.
3. Excel draws arrows to the cells that reference it. Click again to go another level out.
4. Click Remove Arrows to clear them.

Select dependents with the keyboard

Select the cell and press Ctrl+] (Control and the right square bracket) to select its direct dependents. This is quick, but it only covers the active sheet and does not show dependents on other tabs.

Find cross-sheet dependents

Native dependent arrows stop at the sheet boundary and show a small worksheet icon instead of following the link. In a multi-tab model, that hides exactly the dependencies that matter most.

See every dependent in one list with ModelMint

ModelMint lists every cell that references the one you are on, across the whole workbook, and lets you jump straight to any of them. No arrows to clean up, and nothing hidden behind a worksheet icon.