How to Trace Dependents in Excel (2026 Guide)

If you’re not sure which formulas will break when you change a cell, Excel’s built-in Trace Dependents tool draws visual arrows straight to every cell that depends on it, including ones on other sheets, so you can see the impact before you edit anything. Here’s how to turn those arrows on in a couple of clicks.

What Are Dependents (and Precedents)?

A dependent is any cell whose formula uses the value from your selected cell. Change the source cell, and every dependent updates automatically. The opposite, a precedent, is a cell that feeds into your selected cell’s formula. Both concepts live in the same place on the ribbon: Formulas > Formula Auditing.

These steps apply to Excel for Microsoft 365 and Excel 2016 or later on Windows and Mac. Excel for the web and mobile apps have limited or no support for tracer arrows. For more on the differences, see Differences Between Microsoft Excel Online And Excel For Desktop.

How to Trace Dependents in Excel

Step 1: Select your source cell and open Trace Dependents

1. Click the cell whose dependents you want to find, for example, C3, which holds a value used by other formulas.
2. On the ribbon, click the Formulas tab.
3. In the Formula Auditing group, click Trace Dependents.

4. Excel draws solid blue arrows from your selected cell to every cell on the same sheet that references it in a formula.

Keyboard shortcut: Press Ctrl + ] to trace dependents without touching the ribbon. (Ctrl + [ traces precedents.) For more Excel troubleshooting, check out Microsoft Excel “Sharing Violation” Error: Causes and How to Fix.

Step 2: Go deeper, trace multiple levels

If your dependents have their own dependents, one click only shows the first level. Click Trace Dependents again (or press Ctrl + ] again) to extend the arrows another level out. Repeat until you’ve mapped the full chain. For advanced auditing, you can also learn how professionals trace multiple dependents in complex models.

Step 3: Follow dependents on another sheet

When a formula on a different sheet references your selected cell, Excel can’t draw a straight arrow there. Instead it shows a dashed blue arrow pointing to a small worksheet icon at the edge of the screen.

1. Double-click the dashed arrow.
2. A Go To dialog opens, listing every off-sheet dependent cell.
3. Select the cell reference you want to jump to and click OK.

Excel navigates directly to that cell on the other sheet.

Step 4: Remove the arrows when you’re done

1. Go back to Formulas > Formula Auditing.
2. Click Remove Arrows to clear all tracer arrows at once.

Note: If you edit a formula or insert/delete rows or columns, Excel automatically removes the tracer arrows. You’ll need to click Trace Dependents again to regenerate them.

How to Trace Precedents in Excel

Precedents are the flip side: instead of asking “what does this cell affect?”, you’re asking “what cells feed into this formula?” Select a formula cell, like a SUM or AVERAGE, and click Trace Precedents (or press Ctrl + [). Excel draws blue arrows from every input cell pointing toward your selected cell. For a visual guide, you can watch a step-by-step video on how this works.

This is especially useful when you inherit a workbook and need to understand what a formula is actually calculating before you touch it.

Troubleshooting: When Trace Dependents Doesn’t Work

Trace Dependents is greyed out

Two common causes:

• Objects are hidden in the workbook. Go to File > Options > Advanced. Under “Display options for this workbook,” find the “For objects, show” setting and make sure it’s set to All, not Nothing or Placeholders.
• Referenced workbooks are closed. If your formula links to another workbook, that workbook must be open for Excel to trace the connection. Open it, then try again. For more on this issue, see Microsoft’s community answer.

Excel beeps and draws no arrows

Trace Dependents only works on normal worksheet cells. It won’t trace dependents for charts, text boxes, pictures, PivotTables, or named constants. If your selected cell is any of those, or references a closed workbook, Excel will beep and do nothing.

Arrows disappeared after I edited something

This is expected behavior. Any structural change, such as editing a formula, inserting a row, or deleting a column, clears all tracer arrows automatically. Just click Trace Dependents again to redraw them.

I need a full workbook dependency map

Excel’s built-in tool is step-by-step, not a global map. If you need to visualize dependencies across an entire workbook at once, which is common in financial modeling, the built-in arrows won’t cut it. Professional auditors typically use third-party add-ins like Operis Analysis Kit (OAK) or similar tools that generate workbook-wide dependency graphs.

Tracing Dependents in Google Sheets

If you’re working in Google Sheets, there’s no ribbon button, but you have two options:

• Keyboard shortcut: Select a cell and press Ctrl + Shift + ] to highlight its dependents directly in the sheet.
• Find and Replace method: Press Ctrl + H, type the cell reference (e.g., A1 or Sheet1!A1), check Also search within formulas, and set the scope to All sheets. Every formula that depends on that cell will show up as a match. Repeat for locked variants like $A$1 if needed.

Conclusion

For most people, clicking Formulas > Trace Dependents and following the solid blue arrows is all you’ll ever need. The dashed-arrow cross-sheet jump is the feature most people don’t know exists, and it’s a genuine time-saver in multi-sheet workbooks. If the buttons are greyed out, the hidden-objects setting in Excel Options fixes it almost every time.