Highlight All Cells Referenced by the Formula in the Active cell
Master this Excel shortcut with our comprehensive guide
Excel Formula-Related Shortcuts
Ctrl + ]
⌘ + ]
How to Use This Shortcut
Keyboard Shortcut
Ctrl + ]
Instructions
1. Place cursor in a formula cell
2. Press Ctrl + ]
3. Selects all cells that reference the active cell
2. Press Ctrl + ]
3. Selects all cells that reference the active cell
Keyboard Shortcut
⌘ + ]
Instructions
1. Click a formula cell
2. Press Command + ]
3. Shows all dependent cells
2. Press Command + ]
3. Shows all dependent cells
💡 Pro Tip: Quickly find which cells will change if the active cell is modified.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U