How to Move around an Excel Worksheet

By Faithe Wempen

You can move around a Microsoft Excel worksheet using the cell cursor (also called the active cell indicator). The cell cursor is the dark outline around the active cell. To change which cell is active, you can do either of the following:


  • With your mouse: Click the cell you want to be active.

  • From the keyboard: Press one of the arrow keys on the keyboard to move the cell cursor one cell at a time in the direction the arrow is pointing until you reach the cell you want to be active.

The following table provides more shortcuts for moving the cell cursor within a worksheet.

Movement Shortcuts
Press This . . . To Move . . .
Arrow keys One cell in the direction of the arrow
Tab One cell to the right
Shift+Tab One cell to the left
Ctrl+any arrow key To the edge of the current data region in a worksheet (the
first or last cell that isn’t empty)
End To the cell in the lower-right corner of the window(This works
only when the Scroll Lock key has been pressed on your keyboard to
turn on the Scroll Lock function.)
Ctrl+End To the last cell in the worksheet, in the lowest used row of
the rightmost used column
Home To the beginning of the row containing the active cell
Ctrl+Home To the beginning of the worksheet (cell A1)
Page Down One screen down(The cell cursor moves, too.)
Alt+Page Down One screen to the right
Ctrl+Page Down To the next sheet in the workbook
Page Up One screen up(The cell cursor moves, too.)
Alt+Page Up One screen to the left
Ctrl+Page Up To the previous sheet in the workbook