Microsoft Excel · Selection & Navigation

Extend selection to edge of data region

Select from the active cell to the last filled cell in the direction of the arrow key.

++
Mac
⌘ + ⇧ + ↓
Windows
Ctrl + Shift + ↓
Linux
Ctrl + Shift + ↓

More selection & navigation shortcuts in Microsoft Excel

See all 30 Microsoft Excel shortcuts →