# Trace Dependents in Excel: Shortcut & Other Sheets

> Trace dependents in Excel in one click or with Alt+M,D. See every formula that uses a cell, follow dotted arrows to other sheets; Ctrl+] jumps on-sheet.

Page: https://formulaudit.com/guides/trace-dependents-excel

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](https://formulaudit.com/guides/trace-precedents-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

| Action | Windows shortcut |
|---|---|
| Trace Dependents | `Alt+M, D` |
| Trace Precedents | `Alt+M, P` |
| Remove all arrows | `Alt+M, A, A` |
| Go to direct dependents | `Ctrl+]` |
| Select all dependents on the sheet | `Ctrl+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](https://formulaudit.com/guides/trace-precedents-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](https://formulaudit.com/features/explore-precedents-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](https://formulaudit.com/guides/find-circular-references-excel).

## Related guides

- [How to Trace Precedents in Excel](https://formulaudit.com/guides/trace-precedents-excel)
- [How to Find Circular References in Excel](https://formulaudit.com/guides/find-circular-references-excel)
- [Excel Trace Precedents and Dependents Shortcuts](https://formulaudit.com/guides/trace-precedents-dependents-shortcuts)
- [How to Audit a Financial Model in Excel](https://formulaudit.com/guides/audit-financial-model-excel)

## The faster way

Run this check across your entire model with Formula Audit XL: [Explore Precedents & Dependents](https://formulaudit.com/features/explore-precedents-dependents).

## FAQ

### 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.

## Related guides

- [Trace Precedents in Excel: Location & Shortcut](https://formulaudit.com/guides/trace-precedents-excel)
- [How to Find Circular References in Excel](https://formulaudit.com/guides/find-circular-references-excel)
- [Excel Trace Dependents & Precedents Shortcuts](https://formulaudit.com/guides/trace-precedents-dependents-shortcuts)
- [How to Audit a Financial Model in Excel](https://formulaudit.com/guides/audit-financial-model-excel)
