|
 |
|
| |
Using Home, End, Page Up and Page Down
-
Home moves the focus to the start of a row.
-
End moves the
focus to the column furthest to the right that contains
data.
-
Page Down moves
the display down one complete screen and Page Up moves the
display up one complete screen.
-
Combinations of Control and Alt with Home, End, Page Down, Page Up, and the cursor keys move the focus of the current cell in other ways. Table 1 describes all the keyboard shortcuts for moving about a spreadsheet.
|
TIP
|
Holding down Alt+Cursor key resizes a cell.
|
Table 1. Moving from cell to cell using the keyboard
|
Key Combination
|
Movement
|
|
→
|
Right one cell
|
|
â†
|
Left one cell
|
|
↑
|
Up one cell
|
|
↓
|
Down one cell
|
|
Control+→
|
To last column containing data in that row or to Column IV
|
|
Control+â†
|
To first column containing data in that row or to Column A
|
|
Control+↑
|
To first row containing data in that column or to Row 1
|
|
Control+↓
|
To last row containing data in that column or to Row 32000
|
|
Control+Home
|
To Cell A1
|
|
Control+End
|
To lower right hand corner of the square area containing data
|
|
Alt+PgDn
|
One screen to the right (if possible)
|
|
Alt+PgUp
|
One screen to the left (if possible)
|
|
Control+PgDn
|
One sheet to the right (in Sheet Tabs)
|
|
Control+PgUp
|
One sheet to the left (in Sheet Tabs)
|
|
Tab
|
To the cell on the right
|
|
Shift+Tab
|
To the cell on the left
|
|
Enter
|
Down one cells
|
|
Shift+Enter
|
Up one cell
|
|
|
|
