Datasheet

18
•
•
•
2 Press the right arrow key.
•
Excel moves the active cell
one column to the right.
You can press any arrow
key to move the active cell
one cell in that direction.
You can press and hold an
arrow key to repeatedly
move the active cell in
that direction.
3 Press End.
•
The status bar displays
End Mode.
1 Click a cell.
•
Excel makes the cell you
clicked the active cell.
Move Around in a Worksheet
Y
ou can use arrow keys to move around a
worksheet, moving the active cell up, down,
left, or right one cell at a time. If you hold
down an arrow key, Excel moves the active cell
repeatedly in the direction designated by the arrow
key. You can also move one screen at a time by using
the Page Up and Page Down keys.
To quickly move to the first or last cell in a range, you
can take advantage of the End key. You use the End
key in combination with the arrow keys to move the
active cell to the top or bottom cell in a column or the
left or right cell in a row. When you press the End key,
Excel displays End Mode on the status bar to alert you
that the active cell will move to the first or last cell in
the direction of the arrow key you use.
When you know the address of the cell in which you
want to work, you can move directly to that cell by
using the Go To dialog box.
Move Around
in a Worksheet
04_577691-ch01.indd 1804_577691-ch01.indd 18 6/3/10 10:45 AM6/3/10 10:45 AM