Navigation inside Worksheets

  • 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.