Toggle Extend Selection Mode in Excel
Extend Selection mode allows you to expand a selection using arrow keys without holding Shift. This mode is useful when selecting large ranges step by step.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| F8 | Not Available |
What Does This Shortcut Do?
Pressing F8 toggles Extend Selection mode on or off. When enabled, each arrow key press extends the selection instead of moving the active cell.
How to Use the Shortcut
- Select a starting cell
- Press F8 to enable Extend Selection mode
- Use the arrow keys to expand the selection
- Press F8 again to turn the mode off
Tips & Best Practices
- Watch the Excel status bar — it displays “Extend Selection” when enabled
- Combine with arrow keys or Ctrl + arrow keys for faster selection
- Press Esc to cancel the selection if needed
FAQ
- Q: How do I know Extend Selection mode is active?
- The status bar at the bottom of Excel will show “Extend Selection”.
- Q: Does this work on Mac?
- No, the F8 Extend Selection shortcut is available only in Excel for Windows.
- Q: What is the difference between Shift and Extend Selection mode?
- Shift must be held continuously, while Extend Selection mode stays active until turned off.