To Create a Named Range:
- Drag select the cell or range of cells to be named, such as B2 to B5
- Click in the Name box, to the left of the formula bar.
- Type a name for the list, e.g. Jan_sales.
- Press the Enter key on the keyboard.
- 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.


