Extend Selection One Cell Down in Excel (Shift + Down Arrow)
This Excel shortcut helps you extend the current selection one cell downward. It is commonly used when selecting data vertically without using the mouse.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Shift + ↓ | Shift + ↓ |
What Does This Shortcut Do?
Pressing Shift + Down Arrow expands the current selection by one cell below the active cell while keeping the original anchor cell fixed.
How to Use the Shortcut
- Select a starting cell
- Press Shift + Down Arrow
- The selection extends down by one cell
- Repeat to extend further downward
Tips & Best Practices
- Ideal for selecting rows of data vertically
- Combine with Ctrl + Shift + Down Arrow to select continuous data instantly
- Works inside tables, ranges, and empty cells
FAQ
- Q: Does this shortcut work in Excel Tables?
- Yes, it works the same way in tables and normal ranges.
- Q: Can I reduce the selection?
- Yes, use Shift + Up Arrow to shrink the selection.
- Q: Is this shortcut the same on Mac?
- Yes, the shortcut works identically on Windows and Mac.