Office Settings & Configuration

Find, Edit, or Delete Defined Names in Excel

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Find named cells or ranges in an Excel workbook and correct or remove existing defined names.

Find, Edit, or Delete Defined Names in Excel
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.
Before you start

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.

Solution 1Recommended

Manage defined names with Excel Name Manager

Use Name Manager to locate a defined name, edit its reference, or delete and recreate it.

1
Open Name Manager

In Excel, open the workbook, select the Formulas tab, and click Name Manager.

2
Find the defined name

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.

3
Edit the name or reference

Select the name and click Edit. Change the name or the cell reference in Refers to, then click OK.

4
Delete or recreate a name

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.

5
Check dependent formulas

Review formulas that used a deleted or renamed definition and update them to use the correct name if necessary.

Manage defined names with Excel Name Manager
Check the name scope: A defined name can be scoped to the workbook or a specific worksheet. Check the Scope column before editing or deleting it.
Manage named ranges in WPS Office

Manage defined names in WPS Spreadsheets

Use WPS Spreadsheets to review, edit, or remove defined names in a workbook through the Formulas tab.

  1. 1. Open the workbook: Launch WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Open Name Manager: Select the Formulas tab and click Name Manager to display the workbook's defined names.
  3. 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. 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.
Find and update named ranges from Name ManagerOpen and edit Microsoft Excel XLSX and XLS filesWork with formulas in a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.