Part VII: Appendixes
950
TABLE D.1Moving through a Worksheet
Key(s) What It Does
Navigation keys (←, →, ↑, ↓) Moves left, right, up, or down one cell
Home Moves to the beginning of the row
Home* Moves to the upper-left cell displayed in the window
End* Moves to the lower-left cell displayed in the window
Navigation keys* 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+navigation 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 onTABLE D.2Selecting Cells in the Worksheet
Key(s) What It Does
Shift+navigation 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.59_474877-bapp04.indd 95059_474877-bapp04.indd 950 3/29/10 11:47 PM3/29/10 11:47 PM