Microsoft Office Tutorials and References
In Depth Information
Ranges: A Select Tool
Figure 2–12. One column, eleven rows
You’re doubtless getting the idea. Our cell pointer—and that’s what it is—stretches when it selects a
range, serving as its perimeter; and with one clear exception, a bluish fill color identifies exactly those
cells that populate the range (and why the very first cell in a range remains white is a matter to be
And so here’s the point behind all this: if I want to change the font in a range of cells, I can select
those cells I want as illustrated above, and then go ahead and issue a font-change command. And as a
result, only the cells in the range will be affected.
And how do you go about selecting cells in a range? It’s rather easy—and again, both mouse and
keyboard approaches stand at the ready. If you’re mouse-inclined, click the first cell of the desired
range—which is, typically, the upper-left cell in the block of cells you want to select. Keep the mouse
button down, and pull—or drag—across and/or down the cells you want to incorporate into the range.
When you’re done, release the mouse button, and the blue-blanketed range remains selected.
You can also select an entire column by simply clicking a column header—that is, the alphabetized
area in which the columns are named. Doing so highlights that column, as in Figure 2–13: