Extends the selection from the active cell to the last cell in use: the bottom row and the right-most column that hold data. Start in A1 and you have the whole used range, even when it has blank rows that would stop Ctrl+Shift+Down.
More Select shortcuts
- Add another range to the selectionShift+F8
- Turn extend selection mode on or offF8
- Extend the selection by one cellShift+Right
- Select the current region or the whole sheetCtrl+A
- Select the whole columnCtrl+Space
- Select one screen downShift+PageDown
- Select the whole rowShift+Space
- Select to the start of the sheetCtrl+Shift+Home
- Select to the last filled cellCtrl+Shift+Down
- Select to the start of the rowShift+Home