Find, Edit, or Delete Defined Names in Excel
Question details
Find named cells or ranges in an Excel workbook and correct or remove existing defined names.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to locate a defined name and manage its name or cell reference.
- Observed behavior
- The user needs to identify the named range and update or delete its definition through Name Manager.
Open the workbook containing the defined names and check which names are used in formulas. Deleting a name that formulas still use can cause #NAME? errors.
Manage defined names with Excel Name Manager
Use Name Manager to locate a defined name, edit its reference, or delete and recreate it.
In Excel, open the workbook, select the Formulas tab, and click Name Manager.
Locate the name in the list and check its Scope and Refers to columns to identify the associated worksheet or range. Use the Filter button if you need to narrow the list.
Select the name and click Edit. Change the name or the cell reference in Refers to, then click OK.
To remove a name, select it, click Delete, and confirm. If you need a replacement, click New in Name Manager, enter the corrected name and reference, and click OK.
Review formulas that used a deleted or renamed definition and update them to use the correct name if necessary.

Manage defined names in WPS Spreadsheets
Use WPS Spreadsheets to review, edit, or remove defined names in a workbook through the Formulas tab.
- 1. Open the workbook: Launch WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Open Name Manager: Select the Formulas tab and click Name Manager to display the workbook's defined names.
- 3. Change or remove a name: Select a defined name, then use Edit to change its name or reference, or Delete to remove it.
- 4. Save and check formulas: Use File > Save or Save As to save the workbook, then check any formulas that used a changed or deleted name.

Frequently Asked Questions
How do I see all defined names in an Excel workbook?
Open the workbook and select Formulas > Name Manager. The list shows defined names, their references, and their scopes.
How can I find the cells associated with a defined name?
In Formulas > Name Manager, find the name and inspect its Refers to field. You can also select a name from the Name Box to navigate to its range.
Can I change the range assigned to an existing name?
Yes. In Formulas > Name Manager, select the name, click Edit, update the Refers to reference, and click OK.
What happens if I delete a defined name used in a formula?
Formulas that still refer to the deleted name can display a #NAME? error. Update those formulas or create the appropriate replacement name.




