ShortcutdrillExcel shortcuts / navigation / Jump to the cells that use this one
Jump to the cells that use this one in Excel: Ctrl+] (Mac: Ctrl+])
| Windows | Ctrl+] |
|---|---|
| Mac | Ctrl+] |
| Group | navigation |
Drill: Trace the dependent. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+] selects every formula that references the active cell and lands on the first. Use it before changing an input to see what moves.
The common mistake
Checking only the current sheet: Ctrl+] does not follow references from other sheets. Trace Dependents on the ribbon shows those with a dashed arrow.
Related shortcuts
- Move to the next sheet Ctrl+Page Down
- Find the last cell on a wide sheet Ctrl+End
- Back to the top left from anywhere Ctrl+Home
- Select every error cell Ctrl+G, Alt+S, K, Enter
- Jump to the edge of the data Ctrl+Arrow
- The printable cheat sheet
Questions
How do I find every formula that uses a cell?
Ctrl+] on the same sheet. Across sheets, use Formulas, Trace Dependents, or search the workbook for the address with Ctrl+F.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill