Select All Cells Referenced by Formulas
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. Excel highlights all cells referenced in that formula
2. Press Ctrl + [
3. Excel highlights all cells referenced in that formula
Keyboard Shortcut
⌘ + [
Instructions
1. Select a formula cell
2. Press Command + [
3. Highlights all referenced cells
2. Press Command + [
3. Highlights all referenced cells
💡 Pro Tip: Ideal for auditing formulas and tracing dependent cells.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U