The key combinations that allow you to work with selections are listed in the table below.
Moves the active cell one cell down in the selection.
To change this default behavior, use the SpreadsheetSelectionBehaviorOptions.MoveActiveCellMode property.
Moves the active cell one cell up in the selection.
Moves the active cell one cell to the right in the selection.
Moves the active cell one cell to the left in the selection.
Moves the active cell clockwise to the next corner of the selection.
CTRL+ALT+LEFT/RIGHT ARROW KEY
Switches between multiple selected ranges of cells.
Selects only the active cell in the selected cell range.
Selects an entire column in a worksheet.
Selects an entire row in a worksheet.
Selects the entire worksheet or the data region to which the active cell belongs.
Extend the selection by one cell.
Extend the selection to the last nonblank cell in a row or column.
Extends the selection to the first column.
Extends the selection to the beginning of the document.
Extends the selection to the previously used cell in a worksheet.
Extends the selection one screen down in a worksheet.
Extends the selection one screen up in a worksheet.