| Move
and scroll on a worksheet or workbook by using shortcut keys |
| |
|
| To |
Press |
| Move one cell in a given
direction |
Arrow key |
| Move to the
edge of the current data region |
CTRL+ arrow key |
| Move between
unlocked cells on a protected worksheet |
TAB |
| Move to the
beginning of the row |
HOME |
| Move to the
beginning of the worksheet |
CTRL+HOME |
| Move to the last cell on the worksheet, which is the cell at the
intersection of the right-most used column and the bottom-most used row (in
the lower-right corner); cell opposite the Home cell, which is typically A1 |
CTRL+END |
| Move down one
screen |
PAGE DOWN |
| Move up one
screen |
PAGE UP |
| Move one
screen to the right |
ALT+PAGE DOWN |
| Move one
screen to the left |
ALT+PAGE UP |
| Move to the
next sheet in the workbook |
CTRL+PAGE DOWN |
| Move to the
previous sheet in the workbook |
CTRL+PAGE UP |
| Move to the
next workbook or window |
CTRL+F6 or CTRL+TAB |
| Move to the
previous workbook or window |
CTRL+SHIFT+F6 or
CTRL+SHIFT+TAB |
| Move to the
next pane |
F6 |
| Move to the
previous pane |
SHIFT+F6 |
| Scroll to
display the active cell |
CTRL+BACKSPACE |
| |
|
| In End mode, to |
Press |
| Turn End mode on or off |
END |
| Move by one
block of data within a row or column |
END, arrow key |
| Move to the last cell on the worksheet, which is the cell at the
intersection of the right-most used column and the bottom-most used row (in
the lower-right corner); cell opposite the Home cell, which is typically A1 |
END, HOME |
| Move to the last cell to the right in the current row that is
not blank; unavailable if you have selected the Transition navigation keys
check box on the Transition tab (Tools menu, Options command) |
END, ENTER |
| |
|
| With SCROLL LOCK turned on,
to |
Press |
| Turn SCROLL LOCK on or off |
SCROLL LOCK |
| Move to the
cell in the upper-left corner of the window |
HOME |
| Move to the
cell in the lower-right corner of the window |
END |
| Scroll one
row up or down |
UP ARROW or DOWN
ARROW |
| Scroll one
column left or right |
LEFT ARROW or RIGHT
ARROW |
| Tip When you use the
scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off,
your selection moves the distance you scroll. If you want to preserve your
selection while you scroll through the worksheet, turn on SCROLL LOCK first. |
|