Extend Selection One Cell Up in Excel (Shift + Up Arrow)
This shortcut allows you to extend the current selection one cell upward in Excel. It is useful when selecting data vertically with precision.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Shift + ↑ | Shift + ↑ |
What Does This Shortcut Do?
Pressing this shortcut expands the current selection by one cell upward while keeping the starting cell fixed.
How to Use the Shortcut
- Select a starting cell
- Press Shift + Up Arrow
- The selection extends one cell upward
- Repeat the shortcut to extend further
Tips & Best Practices
- Ideal for selecting column data step by step
- Combine with Ctrl + Shift + Up Arrow to select large data blocks
- Works in tables, ranges, and blank cells
FAQ
- Q: Does this shortcut work across worksheets?
- No, it works only within the active worksheet.
- Q: Can I shrink the selection?
- Yes, use Shift + Down Arrow to reduce the selection.
- Q: Is it the same shortcut on Mac?
- Yes, the shortcut works the same on Windows and Mac.