Moving Through a Worksheet

Key(s)	What It Does
Arrow Keys	Moves left, right, up, or down one cell
Home*	Moves to the upper-left cell displayed in the window
End*	Moves to the lower-left cell displayed in the window
Arrow Key*	Scrolls left, right, up, or down one cell
PgUp	Moves up one screen
PgDn	Moves down one screen
Ctrl+PgUp	Moves to the previous sheet
Ctrl+PgDn	Moves to the next sheet
Alt+PgUp	Moves one screen to the left
Alt+PgDn	Moves one screen to the right
Ctrl+Home	Moves to the first cell in the worksheet (A1)
Ctrl+End	Moves to the last nonempty cell of the worksheet
Ctrl+arrow key	Moves to the edge of a data block; if the cell is blank, moves to the first nonblank cell
Ctrl+Backspace	Scrolls to display the active cell
End, followed by Home	Moves to the last nonempty cell on the worksheet
F5	Prompts for a cell address to go to
F6	Moves to the next pane of a window that has been split
Shift+F6	Moves to the previous pane of a window that has been split
Ctrl+Tab	Moves to the next window
Ctrl+Shift+Tab	Moves to the previous window
Ctrl+F6	Moves to the next window
Ctrl+Shift+F6	Moves to the previous window

* With Scroll Lock on

Selecting Cells in the Worksheet

Key(s)	What It Does
Shift+arrow key	Expands the selection in the direction indicated
Shift+spacebar	Selects the entire row(s) in the selected range
Ctrl+spacebar	Selects the entire column(s) in the selected range
Ctrl+Shift+ spacebar	Selects the entire worksheet
Ctrl+Shift+ spacebar*	Selects the table without the header row and totals row. Ctrl+Shift+ spacebar again selects the complete table. Ctrl+Shift+ spacebar again selects the entire worksheet
Shift+Home	Expands the selection to the beginning of the current row
Ctrl+*	Selects the block of data surrounding the active cell
F8	Extends the selection as you use navigation keys. Press F8 again to return to normal selection mode
Shift+F8	Adds other nonadjacent cells or ranges to the selection; pressing Shift+F8 again ends Add mode
F5	Prompts for a range or range name to select
Ctrl+G	Prompts for a range or range name to select
Ctrl+A	Selects the entire worksheet
Ctrl+A*	Selects the table without the header row and totals row. Ctrl+Shift+ spacebar again selects the complete table. Ctrl+Shift+ spacebar again selects the entire worksheet.
Shift+Backspace	Cancels a range selection and selects only the active cell

* If the active cell is within a multicell range