Navigation inside Worksheets

• Dec 01, 2020
• 2 minutes to read

The key combinations that allow you to navigate through a worksheet are listed in the table below.

Shortcut	Description
LEFT ARROW KEY	Moves the active cell one cell to the left in a worksheet.
RIGHT ARROW KEY	Moves the active cell one cell to the right in a worksheet.
UP ARROW KEY	Moves the active cell one cell up in a worksheet.
DOWN ARROW KEY	Moves the active cell one cell down in a worksheet.
ENTER	Moves the active cell one cell down in a worksheet. To change this default behavior, use the SpreadsheetSelectionBehaviorOptions.MoveActiveCellMode property.
SHIFT+ENTER	Moves the active cell one cell up in a worksheet.
TAB	Moves the active cell one cell to the right in a worksheet.
SHIFT+TAB	Moves the active cell one cell to the left in a worksheet.
CTRL+ARROW KEYS	Move the active cell to the edge of the current data region in a worksheet.
END, ARROW KEY	Press END to turn End Mode on and use an arrow key to move to the first or last cell of a data range in the row or column. If cells are blank, the active cell moves to the first or last cell in the row or column. End Mode turns off after you press an arrow key. Press END to activate End Mode again.
HOME	Moves the active cell to the beginning of a row in a worksheet.
CTRL+HOME	Moves the active cell to the beginning of a worksheet.
CTRL+END	Moves the active cell to the last cell in a worksheet (the last edited row of the rightmost edited column).
PAGE DOWN	Moves the active cell one screen down in a worksheet.
PAGE UP	Moves the active cell one screen up in a worksheet.
ALT+PAGE DOWN	Moves the active cell one screen to the right in a worksheet.
ALT+PAGE UP	Moves the active cell one screen to the left in a worksheet.
CTRL+F	Invokes the Find and Replace dialog (with the Find tab activated).
CTRL+H	Invokes the Find and Replace dialog (with the Replace tab activated).
CTRL+PAGE DOWN	Moves to the next worksheet in the current workbook.
CTRL+PAGE UP	Moves to the previous worksheet in the current workbook.