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 ... |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access