Select the array containing 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 any cell of an array formula
2. Press Ctrl + /
3. Selects all cells that belong to the same array
2. Press Ctrl + /
3. Selects all cells that belong to the same array
Keyboard Shortcut
⌘ + /
Instructions
1. Click a cell in an array formula
2. Press Command + /
3. Highlights entire array range
2. Press Command + /
3. Highlights entire array range
💡 Pro Tip: Helps in quickly identifying array formula ranges without manual selection.
Quick Actions
More Excel Formula-Related Shortcuts
Alt + =
Ctrl + Shift + U