You are here: >

Range

1. cell rangeIn general, a range refers to a series of value between two other values. For example, the range between 1 and 5 is 2, 3, and 4.

2. When referring to a spreadsheet, the range or cell range is a group of cells within a row or column. For example, in the formula "=sum(A1:A10)", the cells in column A1 through A10 are the range of cells that are added together. This type of range is referred to as an adjacent range since all of the cells are together. If you wanted to add cells that were in a non-adjacent range each individual cell would need to be in the formula. For example, in the formula "=sum(A1+B2+C3)", the cells A1, B2, and C3 are added together.

Also see: Row, Spreadsheet