Microsoft Office Tutorials and References
In Depth Information
Getting Around the Worksheet and Data Entry
2
Chapter
Getting Around the
Worksheet and Data Entry
The Journey Starts Here
Whether you use a map, a satnav, a web-drawn itinerary, or do the retro thing instead
and question an actual human being, any trip begins with knowing where you’re going,
knowing how to get there, and then deciding what to do once you’ve pulled into your
destination. Your travels across an Excel worksheet aren’t much different. You need to
know where you want to go and how to track that destination down; and once you’re
there, you need to know how to fill that destination with the data that’ll make the
worksheet do what you want it to. It’s a work sheet after all, and we’re going to start
doing that essential work now.
Looking Around
The grid in Excel is a good deal larger than what you’re viewing on screen, and that’s
putting it mildly. In fact, every Excel 2010 worksheet contains 1,048,576 rows, probably
way more than you’ll ever need, and probably more than your computer could handle
anyway were all those rows to be filled with data. And each workbook is outfitted with
16,384 columns, raising an obvious address question: if the 26 th column is called Z, then
what does Excel call number 27? The answer: AA, followed by AB, etc. And when Excel
runs out of double-letter combinations—at column ZZ, it adds a third letter, yielding
AAA, and so on—all the way down to column XFD. Thus, ABC123 is a perfectly legal cell
address.
Getting Around a Worksheet
Now in order to enter data in any cell you have get there first, by maneuvering the cell
pointer into the desired address. Excel gives you many ways of getting there. Here are
some of the standard ways:
31
 
Search JabSto ::




Custom Search