Excel Named Range

To Create a Named Range:

1. Drag select the cell or range of cells to be named, such as B2 to B5
2. Click in the Name box, to the left of the formula bar.
3. Type a name for the list, e.g. Jan_sales.
4. Press the Enter key on the keyboard.
5. The name appears in the Name box.

A named range can be used when creating charts, and in formulas and functions such as:

= SUM( Jan_sales )

= Jan_total + Feb_total + Mar_total

Since a named range doesn't change when a formula is copied to other cells, it provides an alternative to using absolute cell references in functions and formulas.