Trace Precedents in Excel: Location & Shortcut
Updated 2026-11-15
Quick answer
To trace precedents in Excel, select the formula cell and click Formulas, then Trace Precedents. The keyboard shortcut is Alt+M, P. Blue arrows point from the cells that feed the formula to the selected cell. Press the button again to go back another level. A precedent on another sheet shows as a dotted arrow with a worksheet icon; double-click the arrow to open the Go To list. Clear the arrows with Alt+M, A, A.
To trace precedents in Excel, select the cell that holds the formula, go to Formulas, and click Trace Precedents. Or press Alt+M, P. Blue arrows point from every cell that feeds the formula to the selected cell. Click the button again to go one level further back. Clear the arrows with Alt+M, A, A.
What are precedents?
If C10 contains =B5*D3, then B5 and D3 are the precedents of C10. They feed its calculation. Dependents are the other direction: the cells that use C10.
- “Why is this number wrong?” Trace precedents back to the bad input.
- “What changes if I edit this?” Trace dependents forward. See How to Trace Dependents in Excel.
How to trace precedents in Excel
- Select the cell that contains the formula.
- Click the Formulas tab.
- In the Formula Auditing group, click Trace Precedents.
- Read the blue arrows. Each one starts at an input cell and ends at the selected cell. A blue box outlines a range input.
- Click Trace Precedents again to add the next level back.
- Clear everything with Formulas, Remove Arrows.
Trace precedents shortcut in Excel
| Action | Windows shortcut |
|---|---|
| Trace Precedents | Alt+M, P |
| Trace Dependents | Alt+M, D |
| Remove all arrows | Alt+M, A, A |
| Go to direct precedents | Ctrl+[ |
| Select all precedents on the sheet | Ctrl+Shift+[ |
Press the Alt sequences one key after another. Ctrl+[ is different from the arrows: it moves the selection to the cells the formula uses, and if the precedent is on another sheet, it takes you to that sheet. See Excel Trace Precedents and Dependents Shortcuts for the full list.
Trace precedents and dependents together
You can show both directions for one cell:
- Select the cell.
- Press
Alt+M, Pto draw the precedent arrows. - Press
Alt+M, Dto draw the dependent arrows.
Arrows to the cell come from its inputs. Arrows from the cell go to the formulas that use it. To remove only one direction, click the arrow on Remove Arrows and choose Remove Precedent Arrows or Remove Dependent Arrows.
Trace precedents across multiple levels
The cause of a wrong number is often one or two levels back. Press Trace Precedents repeatedly:
- First press: direct inputs.
- Second press: the inputs of those inputs.
- Third press: one level further back.
Stop when you reach cells that hold typed values. Those cells have no formula, so no arrow starts from them.
Trace precedents to another sheet
An arrow cannot cross sheet tabs. When a precedent is on another sheet, Excel draws a dotted arrow that ends at a small worksheet icon at the edge of the current sheet. A dotted arrow is normal. It does not mean the reference is broken.
- Double-click the dotted arrow.
- The Go To dialog opens and lists the cross-sheet references.
- Select a reference and click OK. Excel opens that sheet and selects the cell.
- Repeat Trace Precedents from there to keep going back.
Limits of native Trace Precedents
- It shows the cells a formula uses, not the structure of the formula.
- Each cross-sheet hop needs a double-click and a trip through Go To.
- Arrows from many cells overlap and become hard to read.
- It cannot follow a reference into a closed workbook.
- Editing a formula or inserting rows can clear the arrows, so you redraw them.
Trace precedents with Formula Audit XL
Formula Audit XL opens a precedent tree for the active cell with Ctrl+Q. The tree shows the formula’s function structure and follows references to other sheets, including ranges and named ranges, in one view. Click a node and the cell is selected in the sheet. See Explore Precedents and Dependents for how it works.
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. Arrows can stay visible when you share the file. Run
Alt+M, A, Abefore you send it. - Selecting a cell with no formula. A cell that holds a typed number has no precedents, so no arrows appear.
- Reading a dotted arrow as an error. It marks a precedent on another sheet. Double-click it.
- Spilled arrays. In Excel 365, a spill formula in
A1that fillsA1:A10is traced fromA1, not from each spilled cell. - Circular references. If precedent arrows lead back to the selected cell, the cell is part of a loop. See How to Find Circular References in Excel.
Related guides
The faster way
Run this check across your entire model with Formula Audit XL.
Explore Precedents & DependentsFrequently asked questions
What is the shortcut for Trace Precedents in Excel?
Alt+M, P on Windows. Press the keys one after another, not together. To remove the arrows, press Alt+M, A, A. Separately, Ctrl+[ selects the direct precedents of the active cell, and Ctrl+Shift+[ selects all precedents on the active sheet.
How do I trace precedents and dependents in Excel?
Select a cell, then use Formulas, Trace Precedents (Alt+M, P) for the cells that feed it and Formulas, Trace Dependents (Alt+M, D) for the cells that use it. Both can be on screen at once. Remove them with Formulas, Remove Arrows (Alt+M, A, A), or use the arrow in that button to remove only one direction.
How do I trace precedents back multiple levels?
Click Trace Precedents once to show the direct inputs. Click it again to add the inputs of those inputs. Repeat until you reach cells with typed values, which have no further arrows.
How do I trace precedents to another sheet?
When a precedent 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 references. Select one and click OK to go there.
Can I trace precedents in a closed workbook?
No. Excel cannot trace into a closed workbook. Open the source workbook first. The dotted arrow marks the external reference, but you can follow it only when the file is open.
Why does Trace Precedents show no arrows?
The selected cell has no formula, or the formula has no cell references (for example =1+2). Excel can also show an arrow only for the cell you selected, so check that the active cell is the formula cell.
What is the difference between precedents and dependents?
Precedents are the cells a formula uses. Dependents are the cells that use the selected cell. Trace precedents to find why a number is wrong. Trace dependents to see what changes if you edit a value.