Microsoft Office Tutorials and References
In Depth Information
Getting Around the Worksheet and Data Entry
You can utilize these navigational techniques with the keyboard:
The Enter key—pressing Enter moves the pointer down one row.
The Arrow keys—pressing any of these moves the pointer in the
appropriate direction. That means the down arrow really does the
same thing as Enter when you’re navigating to the next cell– it takes
you down one row.
Tab—moves the pointer one column to the right.
Shift-Tab—moves the pointer one column to the left. (But the
Backspace key won’t work here!)
PgDn/PgUp—when pressed moves the pointer down or up one
screen’s worth of rows. Keep in mind that because you can change
the height of rows, the number of rows you travel with these command
Alt-PgDn/Alt-PgUp—A less-well-known pair of keyboard
combinations. Pressing Alt-PgDn advances the pointer ahead one
screen’s worth of columns . Pressing Alt-PgUp takes the pointer back
one screen’s worth of columns. Again, because you can modify the
width of columns, the distance you’ll travel could vary.
Ctrl-Home—a surprisingly useful combination. Ctrl-Home takes you to
cell A1—the first cell in the worksheet. It’s good to know about when
you’ve travelled a long way across the worksheet, and you need to get
back to the sheet’s beginning.
NOTE: Holding any keyboard navigational key(s) down, and keeping it down, will move the cell
pointer rapidly in the desired direction. Thus if you hold the Enter key down, you’ll scoot swiftly
down the rows of the column in which you find yourself.
ANOTHER NOTE: As we’ve already noted, clicking the scroll buttons moves the worksheet
across, or up or down, the screen. But the scroll buttons don’t move the cell pointer. For
example—if the cell pointer has been positioned in cell A12 and you then click the right scroll
button, you’ll start to see columns well to the right of the A column—but the cell pointer will
remain in A12. Scroll buttons don’t move the cell pointer to a new cell—rather, they just shift the
rows and columns you see across the screen.
Consider this scenario, then: You’re in cell B22 and you want to make your way to cell
Z18. You can click the right scroll button until the Z column appears on screen. Then
just click on Z18 (the column letter doesn’t have to be upper case, by the way). Try it!