The concept of a cell range is one of the most important ideas in Excel.
Arangeis a rectangular group of cells.
For example, both references below are the same:
Ranges can be horizontal or vertical, or both.
Ranges also map perfectly toarrays, a programming concept used in more advanced formulas.
Named ranges
Ranges can be named using thename box.
Named ranges are an easy way to make a formula easy to read and understand.
