Skip to content
Formula Audit XL

Trace Dependents in Excel: Shortcut & Other Sheets

Updated 2026-11-15

Quick answer

To trace dependents in Excel, select the cell and click Formulas, then Trace Dependents. The keyboard shortcut is Alt+M, D. Blue arrows point from the selected cell to every formula that uses it. Press the button again to go one level further. A dependent on another sheet shows as a dotted arrow with a worksheet icon; double-click the arrow to open the Go To list and jump there. Clear the arrows with Alt+M, A, A.

To trace dependents in Excel, select the cell, go to Formulas, and click Trace Dependents. Or press Alt+M, D. Blue arrows point from the selected cell to every formula that uses it. Click the button again to go one level further. Clear the arrows with Alt+M, A, A.

What are dependents?

A dependent of cell A1 is any cell with a formula that refers to A1. If B5 contains =A1*1.2, then B5 is a dependent of A1. Precedents are the other direction: the cells that A1 itself uses.

  • Before you change an assumption, trace its dependents to see what will move.
  • When an output looks wrong, trace its precedents back to the bad input. See How to Trace Precedents in Excel.

How to trace dependents in Excel

  1. Select the cell you want to check.
  2. Click the Formulas tab.
  3. In the Formula Auditing group, click Trace Dependents.
  4. Read the blue arrows. Each one starts at the selected cell and ends at a formula that uses it.
  5. Click Trace Dependents again to add the next level.
  6. Clear the arrows with Formulas, Remove Arrows.

Trace dependents shortcut in Excel

ActionWindows shortcut
Trace DependentsAlt+M, D
Trace PrecedentsAlt+M, P
Remove all arrowsAlt+M, A, A
Go to direct dependentsCtrl+]
Select all dependents on the sheetCtrl+Shift+]

Press the Alt sequences one key after another, not together. Ctrl+] does not draw arrows. It moves the selection to the cells that use the active cell, on the active sheet only. A dependent on another sheet needs the dotted arrow below. See Excel Trace Precedents and Dependents Shortcuts for the full list.

Excel trace dependents to another sheet

An arrow cannot cross sheet tabs. When a dependent is on another sheet, Excel draws a dotted arrow that ends at a small worksheet icon at the edge of the current sheet.

  1. Double-click the dotted arrow.
  2. The Go To dialog opens and lists the cells on other sheets.
  3. Select a cell and click OK. Excel opens that sheet and selects the cell.
  4. Press Alt+M, D again on that sheet to continue the chain.

This works, but each hop is manual. In a model with eight sheets, you repeat it for every sheet that uses the cell.

Trace precedents and dependents together

Select a cell and press Alt+M, P and then Alt+M, D. Arrows into the cell come from its inputs. Arrows out of the cell go to the formulas that use it. To remove one direction only, open the arrow on Remove Arrows and choose Remove Precedent Arrows or Remove Dependent Arrows.

Limits of native Trace Dependents

  • It is built around one active cell, not a block of cells.
  • Each cross-sheet hop needs a double-click and a trip through Go To.
  • Arrows to many cells overlap and become hard to read.
  • It cannot follow a reference into a closed workbook.
  • It does not show the formula that uses the cell, only an arrow to it.

Trace dependents with Formula Audit XL

Formula Audit XL opens a dependents tree for the active cell with Ctrl+Shift+Q. The tree follows the cell across sheets in one view, including cells that use it through ranges or named ranges. Click a node and the cell is selected in the sheet. See Explore Precedents and Dependents.

Formula Audit XL is available as an Excel add-in for Windows and as an AppSource task pane for Windows, Mac, and Excel on the web.

Common pitfalls

  • Leaving arrows on the sheet. Run Alt+M, A, A before you share the file.
  • Expecting arrows from an unused cell. If no formula uses the cell, Excel draws nothing. Ctrl+] checks the active sheet only, so also look for a dotted arrow to another sheet.
  • Hidden rows and columns. Arrows can appear to stop in the middle of the sheet. Unhide the rows or columns and trace again.
  • Legacy array formulas. A multi-cell array formula can draw one arrow to the top-left cell of the array, not to each cell.
  • Loops. If a dependent arrow leads back to the selected cell, the cell is in a circular reference. See How to Find Circular References in Excel.

The faster way

Run this check across your entire model with Formula Audit XL.

Explore Precedents & Dependents

Frequently asked questions

What is the shortcut for Trace Dependents in Excel?

Alt+M, D on Windows. Press Alt, then M, then D, one after another. Remove arrows with Alt+M, A, A. Separately, Ctrl+] selects the direct dependents of the active cell, and Ctrl+Shift+] selects all dependents on the active sheet.

How do I trace dependents to another sheet in Excel?

When a dependent is on another sheet, Excel draws a dotted arrow to a small worksheet icon. Double-click the arrow to open the Go To dialog. It lists the cross-sheet cells. Select one and click OK to jump there. Ctrl+] does not help here: it finds dependents on the active sheet only.

How do I trace precedents and dependents in Excel?

Use Formulas, Trace Precedents (Alt+M, P) for the cells that feed the selected cell and Trace Dependents (Alt+M, D) for the cells that use it. Both sets of arrows can show at once. Remove them with Alt+M, A, A.

Can I trace dependents for several cells at once?

Native Excel is built around one active cell. With a range selected, the arrows overlap quickly and are hard to read, so most people trace cell by cell. The Explore Dependents tree in Formula Audit XL opens a tree for the active cell and follows it across sheets.

Why is Trace Dependents greyed out or not working?

The command is unavailable while you edit a cell, so press Escape first. It can also fail on a protected sheet, or when the cell has no dependents. A cell used only in a closed workbook shows no arrows.

Why do the trace arrows disappear?

Arrows stay until you remove them, but editing a formula or inserting rows or columns can clear them. Click Trace Dependents again to redraw. Also check that the sheet is not protected.

Audit your whole model in minutes

Formula Audit XL runs this check and the full audit across every sheet at once.

For Microsoft Excel on Windows, Mac and the web · No data leaves your machine