Removing a named range

Use the Manage Ranges window to remove a named range without deleting the data that the range contains.

Procedure

  1. Click Insert > Named Range > Manage Ranges.
  2. From the list of named ranges, click the range that you want to remove, and then click the X.
  3. Click OK.
  4. Click Close.