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.

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.

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.