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.
- Click Insert > Name > Define
- Select the named range
- Update its cell range in the Refers to field
- Click Ok
The Defined Names dialogue box appears
Click the Delete button to remove an unwanted named range