Wauvel

Excel like a finance pro.

← The library

Formulas shortcut

Trace dependents

Alt, M, D on Windows, None on Mac.

OccasionalDifficulty 1150 · Proficient
Practice · 2 questions →

When to use it

Trace Dependents: draws arrows from a cell to every formula that uses it.

The shape of it

Windows
Alt, M, D
Mac
None

Worked examples

  • Trace outputs

    Select an input, Alt, M, D → Arrows to every dependent formula

    Impact analysis.

  • Next level

    Alt, M, D again → Next level of dependents

    Downstream chain.

  • Remove arrows

    Alt, M, A, A → Remove arrows

    Cleanup.

Worth knowing

  • A dashed arrow means dependents on another sheet.
  • Ctrl + ] selects instead of drawing.
  • Check before deleting a column.

Where it goes wrong

  • Only direct references are found; INDIRECT is invisible.
  • Arrows remain until removed.

Related

F4Alt + =F9Ctrl + `Ctrl + Shift + EnterCtrl + F3

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.