Microsoft Office Tutorials and References
In Depth Information
Getting Around the Worksheet and Data Entry
Of course you can get to your cell destination with the mouse, by simply clicking it onto
the cell to which you want to go (note that unless otherwise indicated, all mouse clicks
call upon the left button).
You can also use the Name Box to visit a cell. Just click into the box, type your cell
destination, and press Enter. Voila—you’re there.
Figure 2–1. Note the cell pointer in cell B7. Typing H1 in the Name box in pressing Enter takes you to….cell H1.
The Name Box is a cool way to travel long distances in the worksheet with precision -so
if you need to get to cell XY38451, and fast, just type it in the Name Box and press
Enter. Now want to get back where you came? Press Ctrl-Home, and you’re returned to
cell A1.
This table summarizes the techniques we’ve described:
Table 2–1. Navigational techniques summarized
Technique
Type of Movement
Enter key
Moves one row down
Shift-Enter
Moves one cell up
Tab
Moves one cell to the right
Shift-Tab
Moves one cell to the left
Arrow keys
Moves one cell in desired direction
Page-Down/Up
Moves one screen’s worth of rows up or down
Alt-Page Down/Up
Moves one screen’s worth of columns right or left
Ctrl-Home
Always moves to cell A1
Name Box
Moves to cell whose address you’ve typed in box after
Mouse
Enables user to click into any cell
Scroll buttons/bars
Moves to a new area of the worksheet; but does not directly select any cell
 
Search JabSto ::




Custom Search