Trace Precedents & Dependents Shortcuts
Updated 2026-06-03
Quick answer
The Excel shortcut for Trace Precedents is Alt + M, P; for Trace Dependents it is Alt + M, D; remove all arrows with Alt + M, A, A. There is no single-key default, but you can map one via the Quick Access Toolbar. Formula Audit XL adds one-click, cross-sheet tracing without the arrow clutter.
The trace precedents and dependents commands are among the most-used formula auditing tools in Excel, but they have no convenient single-key default. Knowing the correct key sequences, and how to customise them, removes friction that adds up across a full model review.
The complete shortcut reference
| Action | Windows shortcut | Notes |
|---|---|---|
| Trace Precedents | Alt + M, P | Press Alt, then M, then P in sequence |
| Trace Dependents | Alt + M, D | Press Alt, then M, then D in sequence |
| Remove all arrows | Alt + M, A, A | Press Alt, then M, then A, then A |
| Remove precedent arrows only | Alt + M, A, P | Removes only the blue precedent arrows |
| Remove dependent arrows only | Alt + M, A, D | Removes only the blue dependent arrows |
| Navigate to precedent cell | Ctrl + [ | Jumps to the referenced cell (no arrows) |
| Navigate to dependent cell | Ctrl + ] | Jumps to a cell that references this one |
| Error Checking | Alt + M, K | Cycles through formula errors |
| Evaluate Formula | Alt + M, V | Opens the formula step-through dialog |
| Show Formulas toggle | Ctrl + `` | Toggles formula/value display |
How the ribbon sequences work
Alt + M, P is a ribbon key sequence, not a chord. Press and release Alt to activate the ribbon key tips, then press M to open the Formulas tab, then P to activate Trace Precedents. You do not need to hold any key.
On a UK or international keyboard, the letters are the same. M always opens Formulas on the Windows ribbon.
Adding a level of tracing
Press the same shortcut multiple times to extend the trace:
- First
Alt + M, P: draws arrows from the immediate input cells. - Second
Alt + M, P: extends arrows one more level back. - Repeat to trace the full upstream chain.
The same applies to Trace Dependents: each Alt + M, D extends one level further downstream.
Add Trace Precedents to the Quick Access Toolbar
For even faster access, add the commands to the Quick Access Toolbar (QAT):
- Right-click Trace Precedents on the Formulas ribbon.
- Click Add to Quick Access Toolbar.
- Repeat for Trace Dependents and Remove Arrows.
Once added, press Alt + [number] where the number corresponds to the button’s position in the QAT. For example, if Trace Precedents is the 4th QAT button, press Alt + 4. This gives you a two-keystroke shortcut that is faster than the four-key ribbon sequence.
Navigate without arrows: Ctrl + [ and Ctrl + ]
These two shortcuts are underused but valuable:
Ctrl + [selects the cells that the active formula references (precedent navigation). Instead of drawing arrows, Excel physically moves your selection to the input cells.Ctrl + ]selects the cells that reference the active cell (dependent navigation).
After navigating with Ctrl + [, press F5 → Enter (or Ctrl + G → Enter) to return to where you started using the Go To dialog’s “Last” feature.
These are useful for quick spot-checks without leaving a sheet covered in arrows.
Removing arrows before you share a model
Always clear tracing arrows before sending or presenting a model. Arrows distract readers and sometimes persist into print layouts.
Quick clean-up: Alt + M, A, A removes every arrow on the active sheet. Repeat for each sheet, or use Remove Arrows from the ribbon across multiple selected sheets.
Faster navigation with Formula Audit XL
Formula Audit XL replaces the arrow-based trace with a navigable dependency tree that spans every sheet simultaneously. Rather than pressing Alt + M, P multiple times, following dotted cross-sheet arrows, and cleaning up afterwards, you open the trace panel, select a cell, and see the full precedent or dependent chain laid out as a tree. No arrow clutter, no sheet-by-sheet navigation.
Related guides
The faster way
Run this check across your entire model with Formula Audit XL.
Explore Precedents & DependentsFrequently asked questions
Is there a single-keystroke shortcut for Trace Precedents?
No built-in single-key shortcut exists. The default is Alt + M, P (a ribbon sequence). You can create a single-key shortcut by adding Trace Precedents to the Quick Access Toolbar: right-click the Trace Precedents button on the ribbon → Add to Quick Access Toolbar. It appears as a QAT button you can activate with Alt + [position number].
What is the shortcut to remove tracing arrows in Excel?
Alt + M, A, A removes all arrows. To remove only precedent arrows: Alt + M, A, P. To remove only dependent arrows: Alt + M, A, D. These are ribbon key sequences: press Alt first, then each letter in sequence.
What does Ctrl + [ do in Excel?
Ctrl + [ selects the precedent cells of the active formula (moves the selection to the cells the formula references). It does not draw arrows; it physically navigates to the input cells. Ctrl + ] does the same for dependents: it selects the cells that reference the active cell.
Can I use the keyboard to step through Trace Precedents levels?
Yes. Press Alt + M, P once for the first level, then press Alt + M, P again to extend arrows one more level back. Each press extends the precedent trace one step further up the chain.