A range is simply a collection of adjacent cells. These may be in a column, a row, or a larger area consisting of several rows and columns. A range reference is expressed by listing the first and last cells in the range, separated by a colon (:). For example, the range that starts with cell A1 and ends with cell A9 (shown in Figure 17) is written like this: A1:A9 Figure 17. The range of cells specified A1:A9.
As just noted, ranges can run down columns or across rows, or both. For example, a range starting with cell A1 in the top-left corner and running through cell D10 in the bottom-right corner (as shown in Figure 18) is written like this: A1:D10 Figure 18. The range of cells specified A1:D10.
|