Microsoft Office Tutorials and References
In Depth Information
Ranges: A Select Tool
Table 2–1. Cell Navigation Techniques
Technique
Type of Movement
Mouse
Enables user to click any cell
Scroll buttons/bars
Moves to a new area of the worksheet; but does
not directly select any cell
Enter key
Moves one cell 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
Ctrl-End
Travels to last cell containing data (the
lowestright such cell on the worksheet)
Name Box
Moves to cell whose address you’ve typed in box
Go To
Moves to cell whose address you’ve typed in
Reference field
Ranges: A Select Tool
And now for something if not completely, then at least slightly, different. To date, we’ve explored a
variety of ways for meandering across the worksheet, all of which bring us to one particular cell at
journey’s end. But Excel also provides us with the means for occupying more than one cell at the same
time. What does that mean?
Well, it means that it’s time to dust off another one of those have-to-know concepts. This matter
doesn’t originate with Excel, of course, but history aside, spreadsheet users very often need to visit, work
with, or be able to identify a group of cells at the same time. Why?
The reasons are several. For example, a user may want to change the font that currently appears in a
large cluster of cells. Having the ability to bring about that change simultaneously in all those cells is
obviously a great deal more efficient than having to revise each cell individually. After all, what if you
wanted to change the font for, say, 50 million cells?
 
Search JabSto ::




Custom Search