Excel > Excel 2003 Intermediate > Named Ranges

Managing Range Names

You can change the name of a range and the range referenced by a named range if a mistake has been made, or it needs updating. Named ranges can also be deleted if no longer needed.

1. Click Insert > Name > Define

The Defined Names dialogue box appears

2. Select the named range
3. Update its cell range in the Refers to field



4. Click Ok

Click the Delete button to remove an unwanted named range

Using range names in formulas Creating a chart

Guides