A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box.
In the example, the formula in F6 is:
where "sales" is the named range C4:C10. Other examples of formulas that use this same named range are:
=MIN(sales) =AVERAGE(sales) =SUM(sales)
Note: named ranges are absolute references by default.
How to create a named range
To quickly create a named range:
- Select the range
- Type a name into the name box and hit return
Video: How to create a named range.
More detailed information: Named ranges in Excel.