How to delete defined names (named ranges) in Excel
If you’re seeing unexpected or unused named ranges in Excel, you can easily view, edit, or delete them using the Name Manager.
Solution: Use the Name Manager in Excel
-
Open your Excel workbook.
-
Go to the Formulas tab in the ribbon.
-
Click Name Manager.
-
In the list, find the defined name you want to remove.
-
Select the name.
-
Click Delete and confirm.
The defined name is now removed from the workbook.
What else you can do in Name Manager
In the same dialog, you can also:
-
Edit existing names and adjust the ranges they refer to
-
Create new defined names
-
Filter or search to quickly find specific names
Why am I seeing defined names?
Defined names (also called named ranges) are often used in formulas, tables, and data validation. They may have been:
-
Created automatically by Excel
-
Added when copying sheets or templates
-
Set up earlier and no longer needed