To remove a range name in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select the name, choose Delete, confirm, and close the manager. This removes the name—not the cells or their contents. Before deleting it, check its scope and whether formulas, dropdowns, charts, or other workbook features depend on it.
What You’ll Need
- The workbook containing the name. If it is important, save a copy before making changes.
- Access to Excel’s Name Manager. The steps below are for Excel for Microsoft 365 on Windows; desktop Excel is preferable if you are working with names in a workbook opened in a browser.
- A moment to inspect the name’s references and scope, especially if you did not create it or are unsure what uses it.
Step-by-Step
- Open the workbook and save a safety copy. Open the file in Excel and use File > Save As to create a copy if you may need to restore the name or compare the workbook later. Removing a name is a change to the workbook’s structure, and you should not count on Ctrl+Z to restore it.
- Open Name Manager. Select the Formulas tab, then choose Name Manager in the Defined Names group. In Windows desktop Excel, you can also press Ctrl+F3. The manager lists defined names and displays details such as each name’s value, its reference, and its scope.
- Find the exact name you intend to remove. Read the names in the list carefully, including similar names that differ by a character or number. If the list is long, click a column heading to sort it. You can also use the Name Manager’s filter options to narrow the displayed names when an appropriate filter is available.
- Check the Scope column. A name with Workbook scope is available throughout the workbook. A name with a worksheet name in the Scope column is limited to that sheet. Excel can contain a workbook-scoped name and a sheet-scoped name with the same spelling, so selecting the right row matters. Do not assume that deleting one removes every name with that text.
- Inspect what the name refers to. Select the row and read the Refers To field. It may point to a cell or range, such as a worksheet and cell address, or it may contain a formula or constant. If the field is clipped, widen the Name Manager window or use the field to examine the full entry. Confirm that the reference and scope match the name you meant to remove.
- Consider whether anything relies on it. Search formulas for the name and check relevant features such as data validation lists, charts, and workbook print settings. A formula that uses a deleted defined name may return
#NAME?. A dropdown or chart that relies on the name may no longer work as intended. If you cannot tell whether it is safe to remove, leave it in place until you identify its use. - Select the row and delete it. Click the name in the list so the correct row is highlighted, then choose Delete. If Excel asks you to confirm, review the name again and confirm only if it is the one you want removed. Deleting a defined name does not erase the referenced cells or their values.
- Close Name Manager and verify the change. Choose Close, then reopen Formulas > Name Manager to check that the intended name is gone and that similarly named entries remain if you wanted to keep them. Test important formulas, dropdowns, and charts that might have depended on it, then save the workbook.
If the name is a worksheet-scoped name, you can also open Name Manager while that worksheet is active to make it easier to identify sheet-level entries. Still use the Scope column to confirm your selection: the active sheet alone is not a substitute for checking which row you are deleting.
Common Mistakes
- Confusing a name with the cells it refers to. Deleting a defined name removes a label or formula definition. It does not clear, move, or delete the underlying cells. If you want to remove cell contents, select the cells and clear them separately; do not delete the name as a substitute.
- Removing a name with the wrong scope. Workbook-level and worksheet-level names can share a spelling. Check Scope before choosing Delete. If the same text appears in multiple rows, decide which scope you mean and deal with each entry deliberately.
- Deleting a name without checking dependencies. A name may appear in formulas, a data validation source, a chart series, or a print setting. Removing it can leave those features with broken references or changed behavior. The workbook may still open without warning, so test the relevant parts after deletion.
- Assuming a table name is a range name. Excel tables have names used in structured references, but they are managed as tables, not as ordinary defined names. If the item is a table, select a cell in it and use the Table Design tab to review or rename the table. Do not delete a table just to remove its name; that can affect the table’s data and features.
- Removing special names without considering their purpose. Names such as
Print_AreaandPrint_Titlescan control worksheet printing. Deleting one may reset or change print behavior. Only remove a special-purpose name if that is the result you want, and check the sheet’s print setup afterward. - Expecting Ctrl+Z to be a reliable recovery method. Name Manager changes may not be available in Excel’s normal undo history. Save a copy first. If a name is removed accidentally, recreate it using the correct spelling, scope, and Refers To entry, or restore it from the saved copy.
Tips
- Use a descriptive name when recreating one. Names such as
QuarterlySalesare easier to understand than vague labels. Excel names must follow naming rules: they cannot contain spaces, cannot look like a cell reference, and must begin with a letter, underscore, or backslash. - Record the definition before deleting it. If the name may be useful later, note its exact spelling, scope, and Refers To entry. This makes it easier to restore it manually if needed. Copying only the spelling is not enough if the name contains a formula or points to a non-obvious range.
- Use Find as a first check, not as a complete dependency audit. Press Ctrl+F and search for the name in formulas if you suspect it is used. Searching the workbook can reveal some formula references, but may not identify every use in charts, validation settings, or print configuration.
- Clean up names in small batches. Remove one name, check the workbook, and then continue. Deleting many names at once makes it harder to identify which removal caused a broken formula or feature.
- Remember the Mac shortcut difference. On Excel for Mac, open Formulas > Name Manager where available. The Windows shortcut Ctrl+F3 may not behave the same on every Mac keyboard because function keys can control hardware features; using the ribbon avoids that issue. Menu wording or placement can vary slightly by Excel release.
- Be cautious with Excel for the web. Name-management options can differ from desktop Excel and may not expose every feature of a workbook. If you cannot inspect or remove the required name in the browser, open the workbook in the Microsoft 365 desktop app and use Name Manager there.
Troubleshooting
Name Manager is missing or unavailable: Make sure you are in the desktop Excel app and have opened the workbook, then select the Formulas tab. If the ribbon is simplified or collapsed, expand it or use the ribbon search box to look for Name Manager. In a browser, choose the option to open the workbook in the desktop app if the needed name-management controls are unavailable.
The name you want is not listed: Check for spelling differences and inspect any filters in Name Manager. Confirm that you have the correct workbook open. If the name is hidden or belongs to a feature such as a table, it may not appear as an ordinary deletable range name. Table names are managed through Table Design. Some hidden defined names are not displayed in the standard Name Manager list; do not try to remove one with code unless you understand what created it and have a backup.
Delete is unavailable or Excel will not remove the entry: Confirm that a name row is selected and that the workbook is not protected in a way that prevents the change. Some special names or feature-managed entries may need to be changed through the feature that created them. For example, adjust a worksheet’s print area through Page Layout > Print Area rather than treating it like an ordinary user-created name.
A formula shows #NAME? after deletion: The formula probably referred to the deleted name. Reopen Name Manager if the change is still present, recreate the name with the original spelling and correct reference, or edit the formula to use a direct cell reference or another valid name. If you saved a backup before the change, compare the original definition there.
A dropdown or chart stopped working: Check its source or series reference and determine whether it used the deleted name. Restore the name if appropriate, or update the feature to use a valid range or replacement name. Test the result in the affected worksheet; a chart or dropdown can fail even when ordinary cell formulas appear unaffected.
The name seems to return: Check whether you deleted a sheet-level copy but a workbook-level copy remains, or whether another sheet contains a separate scoped name. Also consider whether the workbook is being regenerated or refreshed by an external process or template. Reopen Name Manager and inspect the Scope and Refers To columns rather than deleting every entry with a similar spelling.
Frequently Asked Questions
Does removing a range name delete the cells or data?
No. It removes the defined name from the workbook. The cells and their contents remain where they are, although formulas or features that used the name may need attention.
What is the difference between a workbook name and a worksheet name?
A workbook-scoped name can generally be used throughout the workbook. A worksheet-scoped name applies to one sheet. Excel can have both scopes using the same spelling, so check the Scope column before deleting.
Can I delete a name from the Name Box?
The Name Box can help you select a named range, but it is not the place to remove a defined name. Use Formulas > Name Manager, select the entry, and choose Delete.
Will Excel warn me if a formula uses the name?
Do not rely on a warning that identifies every dependency. A formula that refers to a deleted name can show #NAME?, while other features may simply stop working as expected. Check likely uses and test the workbook after removal.
Can I undo a deleted range name?
Excel may not include Name Manager changes in the ordinary undo history. If you have not saved, check whether Undo is available, but the safer recovery is to restore the name from a copy or recreate it with its exact definition.
Can I delete a name in Excel for the web?
Web capabilities can vary. If Name Manager does not let you inspect and delete the specific entry, open the file in desktop Excel and use Formulas > Name Manager.
Related
- How to Add a Header in Excel When Printing a Worksheet
- How to Add Headers in Excel on SharePoint and Format Them
- Changing Date Format in Excel: Steps, Options, and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Make Bullet Points in Two Columns in WordTo make bullet points appear in two columns in Microsoft Word, place the list in its own section,…
- Open Excel Solver Add-in: Enable and Use ItTo open Solver in Excel for Microsoft 365 on Windows, enable the Solver Add-in at File > Options…
- Google Sheets Filter by Color: Steps and LimitationsYes. In Google Sheets in a web browser, create a filter, open the filter menu on the column…
- Excel Data Validation List: How to Add a Blank OptionYes. To add a selectable blank to an Excel data-validation drop-down, include a genuinely empty cell inside the…
- Create a Questionnaire Template in Word Step by StepTo create a questionnaire template in Microsoft Word, lay out your questions and response areas in a document,…
- Google Sheets Conditional Data Validation ExplainedYes. In Google Sheets, conditional data validation can use a custom formula to allow or reject an entry…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.