Datasheet

Move Around in a Worksheet
Move Around
in a Worksheet
Y
ou can use arrow keys to move around a
worksheet, moving the cell pointer up, down,
left, or right one cell at a time. If you hold
down an arrow key, Excel moves the cell pointer
repeatedly in the direction designated by the arrow
key. You can also move one screen at a time 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
cell pointer to the top or bottom cell in a column, or
the left or right cell in a row. When you use the End
key, Excel displays “End Mode” on the Status Bar to
alert you that the cell pointer 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 using
the Go To dialog box.
•
•
•
1 Click a cell.
•
Excel displays the cell pointer in that cell.
2 Press the right-arrow key on the keyboard.
•
Excel moves the cell pointer one column to
the right.
You can press any arrow key to move the cell
pointer one cell in that direction.
You can press and hold an arrow key to
repeatedly move the cell pointer in that
direction.
3 Press the End key.
•
The Status Bar displays “End Mode.”
16
05_181706 ch01.qxp 1/31/08 9:44 PM Page 16