A range is a group or block of cells on a worksheet that are selected or highlighted. A range can also be a group or block of cell references that are entered as an argument to a function, used to create a chart, or used to bookmark data.
How to Create a Named Range in Excel – Office 365
A contiguous range of cells is a group of highlighted cells that are adjacent to each other, such as the range C1 through C5 shown in the image above.
A non-contiguous range consists of two or more separate blocks of cells. These blocks can be separated by rows or columns, as shown by the ranges A1 through A5 and C1 through C5.
Ranges are so important in Excel and Google Sheets that specific ranges can be given names, making them easier to work with and reuse when referencing them in charts and formulas.
