Microsoft Office Tutorials and References
In Depth Information
Click either of these and keep the mouse button down. Then pull, or drag, the scroll bar across or
down, depending on which bar you’ve selected; the worksheet speeds in the direction you’ve chosen—
but only as far as you’ve already travelled. That is, if you’re currently in column X, for example, you can
only scroll horizontally between that column and column A. Note in addition that when you drag a scroll
bar, Excel displays an accompanying caption, one which notifies you which row or column is going to
end up in the leftmost column or the uppermost row onscreen once you release the mouse button. Try it
and you’ll see what I mean.
But remember this: neither scroll option—neither the buttons nor the bars—will actually take you
into a new cell. To illustrate the point: suppose I click cell C5 and then ride my scroll bar to say, column
AH. This is what you’ll see, in Figure 2—6:
Figure 2–6. Now you see it, now you don’t: Cell C 5 remains selected, even though you’ve scrolled quite a
way beyond it.
You’ve made it to column AH, but look at the name box, the field that always records the current cell
pointer location. You’re still “in” C5, even though you can’t even see that cell onscreen right now. And,
as a matter of fact, if you begin to type now, that data will be installed in...cell C5 (and note that row
heading number 5 is colored, reminding you that this row continues to be occupied by the cell pointer).
The larger point, then, is that scrolling will only enable you to view new areas of the worksheet. If
you want to actually move into cell AH1, for example, you’ll still have to click it.
As you may have gathered, then, there is a kind of hit-or-miss quality to mouse moves. Clicking or
dragging or scrolling in the direction you want to go, in the hope of landing precisely in the cell you’re
seeking, can be something of a challenge—particularly if you want to travel a long way across the
worksheet. If I need to deposit the cell pointer in cell AB367, for example, and I’m starting cell from D8, I
may have to do quite a bit of clicking and dragging until I end up at that address—if I rely on my mouse.
But Excel supplies us with a range of keyboard navigational maneuvers that also allow us to home in on
the cell we want; and again, some of these are rather self-evident. First, pressing the Enter key bumps the
cell pointer down one row—though keep in mind it is possible to change the direction an Enter press