A range may refer to any of the following:

  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. 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 called 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.

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

  • Help, examples, and information on Excel formulas.

Row, Spreadsheet, Spreadsheet terms