Microsoft Office Tutorials and References

In Depth Information

**Ranges: A Select Tool**

In addition, Excel users very often need to perform some sort of mathematical operation on a gaggle

of cells at the same time. Indeed, isn’t adding rows or columns of numbers—the classic Excel task—

exactly what we’re talking about here?

So in order to do this kind of work we need to be able to define
ranges
on the worksheet. Strictly

speaking, a range is any collection of cells that has been selected or identified at the same time. But more

conventionally put, a range is a set of
adjacent
cells
that exhibit a rectangular shape—and the concept is

far simpler than it sounds.

Figure 2–10, for example, is a range:

Figure 2–10.
A typical range

As is Figure 2–11:

Figure 2–11.
Another range example, this one narrower and shorter

And so is Figure 2–12: