Table of Contents

Navigation inside Worksheets

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