Range

Updated: 01/18/2023 by Computer Hope

A range may refer to any of the following:

cell range

1. In general, a range refers to several values between two other values. For example, the range between 1 and 5 is 2, 3, and 4.

2. With spreadsheets, 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 added together. This type of range is called an adjacent range since all cells are together. To add cells in a non-adjacent range, each cell needs to be in the formula. For example, in the formula =sum(A1+B2+C3), the cells A1, B2, and C3 are added together.

3. With computer programming, a range may be represented with two (..) or three (...) periods. See our ellipsis page for further information and examples.

Programming terms, Row, Spreadsheet, Spreadsheet terms