Removing a named range
Use the Manage Ranges window to remove a named range without deleting the data that the range contains.
Procedure
- Click .
- From the list of named ranges, click the range that you want to remove, and then click the X.
- Click OK.
- Click Close.