How to trace precedents across sheets in Excel
To trace precedents across sheets, select the formula cell, open Formulas, then Formula Auditing and click Trace Precedents. Arrows appear for references on the same sheet. For a reference on another sheet, double-click the black arrow to open the Go To dialog, then pick the reference.
The native Excel method
- Select the cell containing the formula you want to trace.
- On the Formulas tab, in the Formula Auditing group, click Trace Precedents.
- Click Trace Precedents again to step back another level, until Excel beeps, which means every level has been traced.
- Double-click the black arrow that points to another worksheet or workbook to open the Go To dialog.
- Double-click the reference you want in the Go to list to select that cell.
- Press F2 while a cell is selected to see its colour-coded precedents in the formula.
What the native method does well
Trace Precedents is built into Excel and needs nothing installed. Microsoft’s support page describes the arrows and the two definitions the feature rests on: a precedent is a cell referred to by a formula in another cell, and a dependent is a cell whose formula refers to another cell (Microsoft Support).
Pressing F2 with a cell selected shows the colour-coded precedents inside the formula itself, which is often faster than reading arrows.
Where it gets awkward
The arrows only describe the current screen state. Microsoft notes that all tracer arrows disappear when you change the formula they point to, insert or delete rows or columns, or move cells — you have to run the auditing commands again to get them back (Microsoft Support).
Some things cannot be traced at all: references to text boxes, embedded charts or pictures, PivotTables, named constants, and formulas in another workbook that is closed. Excel also beeps when you have traced every level, which is easy to mistake for an error.
The CalcoraSuite way (planned)
The formula explorer is planned to keep the whole chain in one view with the sheet named at every step, so a cross-sheet reference reads as a path rather than a jump. It is not released yet; its status is on the formula explorer page.
The CalcoraSuite way
Planned, not released. The formula explorer page carries the current status of each step (planned).
- Select the total and open the formula explorer.
- Walk the chain one level at a time, with the sheet named at each step.
- Stop where a number was typed rather than calculated, because that is the point a review has to check.
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.