Select Current Array in Excel
The Select Current Array shortcut allows you to instantly select the entire dynamic array or spilled range that the active cell belongs to. This is especially useful when working with modern Excel array formulas.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + / | Cmd + / |
What Does This Shortcut Do?
When your cursor is inside a dynamic array, pressing this shortcut selects all cells generated by that array. It automatically expands to cover the full spill range.
How to Use the Shortcut
- Click any cell inside a dynamic array or spilled result
- Press Ctrl + / (Windows) or Cmd + / (Mac)
- The entire array range will be selected instantly
When This Shortcut Is Useful
- Formatting spilled array results
- Copying dynamic array outputs
- Applying borders or conditional formatting
- Understanding array boundaries quickly
Tips & Best Practices
- Works best with modern Excel dynamic arrays
- Does not select unrelated adjacent data
- Very helpful when arrays resize automatically
FAQ
- Q: Does this work with traditional Ctrl + Shift + Enter arrays?
- It mainly targets modern dynamic arrays, but behavior may vary.
- Q: What if my cell is not part of an array?
- The shortcut will have no effect.
- Q: Is this shortcut available in older Excel versions?
- It works best in Excel versions that support dynamic arrays.