How to trace dependents in Excel

Native steps checked against Microsoft Support on 16 November 2026 · updated 16 November 2026

To trace dependents in Excel, select the cell and use Formulas, then Formula Auditing and Trace Dependents. Arrows point from your cell to every formula that reads it. Click again to go further. Excel beeps when every level is traced, or when the cell cannot be traced at all.

The native Excel method

  1. Select the input cell or calculation you want to check.
  2. On the Formulas tab, in the Formula Auditing group, click Trace Dependents.
  3. Click Trace Dependents again to follow the chain outward, one level per click.
  4. Double-click a black arrow that leaves the worksheet to open the Go To dialog and jump to the referencing cell.
  5. Use Remove Arrows to clear the display before printing or sending the workbook.

Why dependents matter more than precedents

Precedents answer “where does this number come from”. Dependents answer “what breaks if I change it”, which is the question a reviewer asks before moving an input. Microsoft’s support page defines a dependent as a cell containing a formula that refers to another cell, and both traces live in the same Formula Auditing group (Microsoft Support).

What the native trace will not follow

The support page lists the items that cannot be traced: references to text boxes, embedded charts or pictures, PivotTable reports, named constants, and formulas in another workbook that refer to the active cell when that workbook is closed (Microsoft Support).

For a financial model that is a real limit: a value that feeds a chart in a deck, or a PivotTable in a summary tab, will show as having no dependents even though something downstream consumes it.

The CalcoraSuite way (planned)

The planned explorer lists dependents per sheet rather than as arrows, and keeps the list attached to the finding so a review note can quote it. The formula explorer page carries its status.

The CalcoraSuite way

Planned, not released. The formula explorer page carries the current status of each step (planned).

  1. Select the cell and open the explorer on the dependent side.
  2. See every formula that reads it, grouped by sheet.
  3. Jump to any dependent to read the formula in place.

Sources

Every native step above was checked against these Microsoft pages on 16 November 2026.

Get the add-in before release

Early access testers get each add-in first, with a short list of what to try.