Software - Spreadsheets
Ranges


A 'range' is a group of cells which form a rectangular block.
A range can be selected by dragging the mouse over the cells.

© Microsoft Corporation
The selected values that we see in the "In Range" example above are contained within a range defined as B3:D4. Ranges are defined with the address of the first selected cell and the address of the last selected cell.

Selecting a range allows you to apply changes that affect all the cells contained inside the range.

  • A range might be selected in order to enter the same value in all the selected cells.
  • A range might be selected in order to print out a defined area of the worksheet.