Move and Scroll—Worksheets

Press

To

Arrow keys

Move one cell up, down, left, or right.

Ctrl+Arrow key

Move to the edge of the current data region.

Home

Move to the beginning of the row.

Ctrl+Home

Move to the beginning of the worksheet.

Ctrl+End

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

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.

F6

Switch to the next pane in a worksheet that has been split.

Shift+F6

Switch to the previous pane in a worksheet that has been split.

Ctrl+Backspace

Scroll to display the active cell.

F5

Display the Go To dialog box.

Shift+F5

Display the Find and Replace dialog box.

Shift+F4

Repeat the last Find action ...

Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.