The best keyboard shortcuts for moving in a workbook

Applies to
Microsoft Excel 2000

The best way to move around in a workbook is to get to know the keyboard shortcuts PAGE UP and PAGE DOWN. Used with the ALT key, each combination scrolls through the worksheet one screen's width.

Picture of which directions PAGE UP, PAGE DOWN, ALT+PAGE UP, and ALT+PAGE DOWN scroll through the screen.

There are other useful keyboard shortcuts to use for moving in a workbook.

Press To
PAGE DOWN Move down one screen
PAGE UP Move up one screen
ALT+PAGE DOWN Move one screen to the right
ALT+PAGE UP Move one screen to the left
CTRL+HOME Move to the beginning of the worksheet
CTRL+END Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottommost used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
CTRL+PAGE DOWN Move to the next sheet in the workbook
CTRL+PAGE UP Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB Move to the next workbook or window

For more information about keyboard shortcuts, type shortcuts in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.