Understanding Ranges


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.





Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net