Work with Selections

• Jun 20, 2018
• 2 minutes to read

The key combinations that allow you to work with selections are listed in the table below.

Shortcut	Description
ENTER	Moves the active cell one cell down in the selection. To change this default behavior, use the SpreadsheetSelectionBehaviorOptions.MoveActiveCellMode property.
SHIFT+ENTER	Moves the active cell one cell up in the selection.
TAB	Moves the active cell one cell to the right in the selection.
SHIFT+TAB	Moves the active cell one cell to the left in the selection.
CTRL+PERIOD (.)	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.
SHIFT+BACKSPACE	Selects only the active cell in the selected cell range.
CTRL+SPACEBAR	Selects an entire column in a worksheet.
SHIFT+SPACEBAR	Selects an entire row in a worksheet.
CTRL+A	Selects the entire worksheet or the data region to which the active cell belongs.
CTRL+SHIFT+SPACEBAR	Selects the entire worksheet or the data region to which the active cell belongs.
SHIFT+ARROW KEYS	Extend the selection by one cell.
CTRL+SHIFT+ARROW KEYS	Extend the selection to the last nonblank cell in a row or column.
SHIFT+HOME	Extends the selection to the first column.
CTRL+SHIFT+HOME	Extends the selection to the beginning of the document.
CTRL+SHIFT+END	Extends the selection to the previously used cell in a worksheet.
SHIFT+PAGE DOWN	Extends the selection one screen down in a worksheet.
SHIFT+PAGE UP	Extends the selection one screen up in a worksheet.