Range

Updated: 10/17/2017 by Computer Hope

A range may refer to any of the following:

cell range1. In 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 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.

Row, Spreadsheet, Spreadsheet terms