How to Trace Dependents in Excel

Formula Auditing · Updated June 2026

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.

Trace Dependents draws arrows from the selected cell out to every formula that reads from it, and double-clicking an arrow jumps to the cell at its other end.

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

Check the blast radius before you edit

The reason to trace dependents is risk. Before you delete a row, overwrite an assumption, or repurpose a cell, the dependents show exactly which formulas will move. Deleting a cell that other formulas read from turns each of them into a #REF! error, so tracing first prevents a cascade you then have to chase down.

On a large model this is the difference between a confident edit and a surprise. Knowing the full set of affected cells lets you update them deliberately rather than discovering broken outputs three tabs away.

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.

Do it in one click

Find Dependents

List every cell and sheet that references the one you are on, then jump straight to any of them.

Get ModelMint See how it works

FAQ

What is the shortcut to trace dependents in Excel?

Select the cell and press Ctrl+] to select its direct dependents on the active sheet.

Why can't I see dependents on other sheets?

Excel's built-in dependent arrows stop at the worksheet boundary and show a worksheet icon rather than following the reference. To find cross-sheet dependents, use a workbook-wide tool like ModelMint's Find Dependents.

How do I remove the trace arrows?

On the Formulas tab, in the Formula Auditing group, click Remove Arrows to clear them all. The small dropdown next to it lets you remove just precedent arrows or just dependent arrows if you want to keep one set.