Microsoft Office Tutorials and References
In Depth Information
Still One More Selection Technique—The Name Box
Figure 2–5. Complete coverage: what the worksheet looks like when you’ve selected all its cells
As we just indicated, a group of adjoining cells of the kind we’ve illustrated above is
called a range , a key spreadsheet concept. Knowing how to identify ranges in
formulas—something we’re going to learn about soon—will enable you to work with
large numbers of cells at the same time: to add the numbers entered in those cells,
calculate their average, find the smallest number among them, and to carry out a nearly
unlimited number of other tasks.
Still One More Selection Technique—The Name Box
And while we’re at it, here’s another cool way to select a range. You can click in the
Name Box and type a range reference, something like
Figure 2–6. Entering range coordinates in the Name Box
Now what does that mean? It means we want to select all the cells from A12 though
C23 (including A12 and C23). That’s what the colon does—and if you press Enter next,
all those cells will be selected.
Search JabSto ::

Custom Search