How to Change a Range Name in Excel and Fix References

To change a named range in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select the name, choose Edit, enter the new name, and click OK. Excel usually updates formulas in the workbook that use that name. Before you begin, note what the range refers to and whether its scope is the whole workbook or a particular worksheet.

What You’ll Need

An Excel workbook with a named range you want to rename. A named range is a label assigned to one or more cells, such as SalesData for B2:B50.
Permission to edit the workbook. If it is read-only, protected, or shared with editing restrictions, you may need to save an editable copy or ask the workbook owner.
The new name you plan to use. Choose a short, descriptive name that follows Excel’s naming rules and does not conflict with another name in the same scope.

Step-by-Step

Save a working copy. Save the workbook before changing names, especially if it contains many formulas, charts, PivotTables, or macros. This gives you a way back if the change has unexpected effects. If the workbook is stored in OneDrive or SharePoint, check that your changes have finished syncing before you close it.
Identify the existing name and its range. Open the Formulas tab and select Name Manager. In the list, find the name you intend to change. Check the Refers To and Scope columns. Refers To shows the cell reference or formula behind the name; Scope shows whether the name applies to the workbook or just one sheet. Write these details down or take a screenshot so you can confirm the replacement points to the same cells.
Select the name and open its edit dialog. In Name Manager, click the correct row, then choose Edit. Check the displayed name carefully before making changes. A workbook can contain similar names, including sheet-specific names, so do not rely on a partial match. If the name is a table name rather than a defined range, see the note in Troubleshooting: table names are changed from the Table Design tab, not here.
Enter a valid replacement name. In the Edit Name dialog, replace the text in the Name box. Names cannot contain spaces, cannot be written like a cell reference such as A1, and must begin with a letter, an underscore, or a backslash. Use letters, numbers, periods, or underscores after the first character. For example, change Sales_Data_Old to MonthlySales. Do not type an equals sign or a cell address into the Name box.
Keep the reference and scope intact. Unless you also intend to change what the name points to, leave Refers To unchanged. Check that the sheet or workbook scope is still the one you noted earlier. In most cases, the scope cannot be changed for an existing name in the edit dialog. If you need a different scope, create a separate name with the required scope and migrate uses deliberately rather than assuming a rename changed it.
Commit the rename. Click OK in the Edit Name dialog, then close Name Manager. If Excel reports that the name is invalid or already in use, correct the name or choose another one. Names must be unique within their scope; a worksheet-level name and a workbook-level name can sometimes share text, but that can make formulas harder to understand.
Check formulas and outputs. Look through a few formulas that used the old name and confirm Excel now shows the new name and calculates the expected results. Also check charts, data validation, conditional formatting, and other workbook features that may refer to the named range. Save the workbook after checking. If the new name is not visible in a formula, do not delete anything immediately; use the troubleshooting steps below to locate remaining references.

Alternative route: You can use the Name Box to inspect a named range, but it is not the best place to rename an existing one. The Name Box is at the left of the formula bar and can navigate to a name or help create one. For changing an existing name, Name Manager makes the reference and scope visible and reduces the chance of editing the wrong item.

Common Mistakes

Changing the range as well as the name by accident. The Refers To field defines which cells the name represents. If you edit that field while renaming, the new name may point to different cells. Compare it with your notes before confirming.
Using a name Excel will reject. Spaces and cell-like labels such as C7 are not valid names. A name such as Q1 Sales will fail; use Q1_Sales or Q1Sales instead. Excel may also reject a name already used at the same scope.
Confusing a named range with a table name. A table has its own name, commonly used in structured references such as Table1[Amount]. Renaming a defined name in Name Manager does not rename the table itself.
Assuming every reference is inside the workbook. Formulas in other workbooks, copied text, documentation, or external links may still contain the old name. Excel cannot update references in a separate workbook that is closed or unavailable.
Overlooking worksheet scope. A name may apply only on one sheet. Another sheet can have a different name with the same spelling. Confirm the scope before selecting or replacing a name.

Tips

Choose names that describe the data or purpose, such as ProductPrices or InputTaxRate, rather than temporary labels such as Range2. Descriptive names make formulas easier to read later.
Use one consistent style, such as CamelCase or underscores, and avoid names that are almost identical. A clear difference between CurrentSales and PriorSales is easier to spot than several names differing by one character.
Use Name Manager’s Refers To column to check whether the range includes the intended rows. A name can refer to a fixed address, a formula, or a dynamic range; renaming it should not unintentionally change that definition.
For a workbook with many names, sort or scan the Name Manager list and check the scope column before editing. Keep a small change log if names are part of a shared reporting process, so collaborators know which label changed.
On Excel for Mac, the comparable route is the Formulas tab > Name Manager; dialog labels can vary slightly by release. Excel for the web has fewer name-management capabilities than the Windows desktop app. If you cannot edit a name there, open the workbook in desktop Excel rather than trying to rename it by typing over the Name Box.

Troubleshooting

The Name box is unavailable or Excel rejects the new name: Check for spaces, a leading number, cell-reference-like text, or a duplicate name at the same scope. Try a simple name beginning with a letter, such as AnnualCost. Also make sure you selected a defined name rather than a built-in item or table.

The Name field cannot be edited: Confirm you selected a user-defined name and chose Edit, not New or Delete. If the workbook or name is protected, or your Excel build does not allow the direct edit, use a controlled replacement: create a new name with the same Refers To target and the intended scope, update formulas that use the old name, verify the results, and only then remove the old name. Do not delete the original first; formulas left behind can display #NAME?.

Formulas show #NAME? after the change: Click a formula cell and inspect the formula bar for the old spelling, a typo, or a name that was local to a different sheet. If you used the replacement method, search formulas for the old name and update the affected formulas. Check formulas in each worksheet, and check defined names whose own Refers To entries may use the old name. Keep the original name until these checks are complete.

A chart, validation list, or conditional format no longer works: Open the relevant feature’s settings and inspect its source. For a chart, select it and review the data source; for data validation, select an affected cell and open Data > Data Validation. Replace a lingering old reference with the new name, then test the feature on a few cells or data points.

You cannot find the name you expected: In Name Manager, inspect the Scope column and select the relevant worksheet from the workbook. Names with worksheet scope may be listed alongside workbook-scoped names. Also check whether the item is actually a table name, a formula label, or a cell address rather than a defined name.

Frequently Asked Questions

Will renaming a range change the cells it points to?
No, not if you change only the Name field. The Refers To entry determines the cells. Review it before and after the rename to make sure it stayed the same.

Will Excel update formulas that use the old name?
When you rename a defined name through Name Manager, Excel ordinarily updates formulas in that workbook that refer to it. Still check important formulas and other features, particularly if the workbook contains external links or references stored as text.

Can I change a range name in the Name Box?
The Name Box is useful for jumping to a named range and for creating names, but use Formulas > Name Manager to edit an existing name. This also lets you inspect its scope and cell reference.

Can two ranges have the same name?
Names must be unique within their scope. Excel can have a workbook-scoped name and a worksheet-scoped name with the same spelling, but the sheet-level name can take precedence on that sheet. Avoid duplicates unless you have a specific reason to use them.

How do I rename an Excel table instead?
Click a cell in the table, open the Table Design tab, and edit the Table Name box. Table names cannot contain spaces, and formulas using structured references may adjust when the table is renamed. This is separate from changing a named range.

Can I rename several ranges at once?
Name Manager edits one name at a time. For multiple names, work through them individually and verify each reference and scope as you go. Avoid broad Find and Replace changes unless you review the matches carefully, because a name can also appear in comments, text, or unrelated formulas.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.