Managing Range Names
You can change the name of a range and the range that it references. Named ranges can also be deleted if no longer needed.
To edit a named range:
- Click the Formulas tab on the Ribbon
- Click the Name Manager button in the Defined Names group
- Select the named range and click the Edit button
- Rename the range by editing the Name field or update the cell range in the Refers to field.
- Click Ok
- Close the Name Manager
The Name Manager dialogue box appears
The Edit Name dialogue box appears
The named range is updated with your changes.
Click the Delete button in the Name Manager to remove an unwanted named range.