Excel Keyboard Shortcuts Navigating in Cells

Move to the previous cell in a worksheet or the previous option in a dialog.

Move one cell up in a worksheet.

Move one cell down in a worksheet.

Move one cell left in a worksheet.

Move one cell right in a worksheet.

Move to the edge of the current data region in a worksheet.

Enter the End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column.

Move to the last cell on a worksheet, to the lowest used row of the rightmost used column.

Extend the selection of cells to the last used cell on the worksheet (lower-right corner).

Move to the cell in the upper-left corner of the window when Scroll Lock is turned on.

Move to the beginning of a worksheet.

Move one screen down in a worksheet.

Move to the next sheet in a workbook.

Move one screen to the right in a worksheet.

Move one screen up in a worksheet.

Move one screen to the left in a worksheet.

Move to the previous sheet in a workbook.

Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells.

Open the list of validation choices on a cell that has data validation option applied to it.

Cycle through floating shapes, such as text boxes or images.

Exit the floating shape navigation and return to the normal navigation.