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.

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.