Excel Can’t Delete a Named Range? Causes and Fixes

How-to basics · Updated November 19, 2026

Yes, you can delete a named range in Excel for Microsoft 365 on Windows: choose Formulas > Name Manager, select the name, and click Delete. If Excel seems unable to delete it, the item may be a table name rather than a named range, the wrong scope may be selected, or the name may be hidden or managed by an add-in.

What a named range is—and what deleting it does

A named range is a label that refers to a cell, a group of cells, or sometimes a formula. For example, a workbook might have a name called QuarterlySales that refers to Sheet1!$B$2:$B$5. A formula can then use the label instead of the cell addresses. Names can make formulas easier to read, but they are separate from the cells themselves.

Deleting a name removes that label and its reference; it does not erase, move, or format the cells it pointed to. If QuarterlySales refers to B2:B5, those cells and their values remain after you delete the name. Formulas that depended on it may no longer work, however, so check for uses before removing a name from a shared or important workbook.

Excel also has other items that look similar but are managed differently. Table names, chart series names, and labels shown in the Name Box are not necessarily defined names. Identifying the item type is often the key to resolving a deletion problem.

Delete a named range in Name Manager

In desktop Excel for Microsoft 365 on Windows, use the ribbon rather than trying to delete the name from a worksheet cell:

  1. Open the workbook and select Formulas > Name Manager. The Windows shortcut is Ctrl+F3.
  2. In the list, select the name you intend to remove. Check its Name, Value, and especially Scope before proceeding.
  3. Click Delete, confirm the prompt, and then click Close.

If you do not see the name, inspect the list carefully and check any available filters. The Name Manager can contain many entries, and the same spelling can appear more than once if one name is scoped to the workbook and another to a particular sheet. Selecting a name is not the same as selecting the cells it refers to, so do not use the worksheet Delete key expecting it to remove a defined name.

Check the name’s scope before deleting it

Every defined name has a scope. A workbook-scoped name is available throughout the workbook, while a worksheet-scoped name is specific to one sheet. Excel allows a sheet-scoped name to have the same spelling as a workbook-scoped name. As a result, you may see two entries that look like duplicates even though they refer to different things.

Use the Scope column in Name Manager to tell them apart. For example, a workbook-scoped name called TaxRate could refer to a cell on a Settings sheet, while a sheet-scoped TaxRate on the East sheet refers to a different cell. Deleting one does not automatically delete the other. If the one you want is hard to distinguish, inspect the Refers to field and note the scope before clicking Delete.

This distinction also explains why deleting a name may not change a formula on the sheet you are viewing: that formula might be resolving to a second name with the same spelling. Conversely, a formula elsewhere may break if you remove the workbook-scoped version that it uses.

Why Excel may seem unable to delete the name

Several different situations can look like a failed deletion. Work through these checks rather than repeatedly clicking Delete:

  • You selected a table name. Excel tables are objects with their own names; they are not ordinary defined names. See the next section.
  • The wrong entry is selected. Names can share spelling across scopes. Confirm the Scope and Refers to fields.
  • The list is filtered or the name is difficult to find. Clear any Name Manager filters and review the full list.
  • The workbook cannot currently be edited. If it is opened read-only, in Protected View, or with editing disabled by permissions, enable editing or obtain an editable copy. Save a copy first if you are unsure about the workbook’s status.
  • An add-in or macro recreates the name. If a name disappears and then returns, a workbook macro, add-in, or template may be creating it again. Check when it comes back and whether it happens after reopening the file or running a particular process.
  • The entry is a hidden or system-generated name. Some names created by Excel or other software are not presented like ordinary user-created names. A normal Name Manager deletion may not expose every hidden entry.

Workbook-structure protection is primarily intended to prevent changes such as adding, deleting, hiding, or moving sheets; it is not the same thing as locking a cell range. If a command is unavailable, look at the actual message and the workbook’s editing state rather than assuming that sheet protection is always the cause. A password-protected or organization-managed file may require permission from its owner.

A table name is not a named range

Excel tables have names used in structured references, such as SalesTable. They are managed through the table tools, not by deleting a defined name in Name Manager. Click a cell inside the table and open the Table Design tab; the Table Name box shows and lets you change its name. The exact tab label can vary slightly in other Excel versions.

If your goal is simply to stop using a particular table name, renaming the table is usually the relevant action. If you want to remove the table structure altogether, use Table Design > Convert to Range and confirm. This keeps the existing cell data but removes table behavior, such as automatic expansion and structured references. Formulas that used the table can be affected, so review them first. Converting to a range is not the same as deleting a named range.

What happens to formulas that use a deleted name?

Excel generally allows you to delete a defined name even when formulas refer to it. Those formulas may then display #NAME? because Excel can no longer resolve the label. A name can also be used in data validation, conditional formatting, charts, or other workbook features, so checking only visible cell formulas may not reveal every dependency.

Before deleting a name that might be in use, use Find to search formulas for its spelling. In Excel for Windows, press Ctrl+F, choose the search options, set Look in to Formulas, and search for the name. This is a useful check, not a complete dependency audit: a name may be referenced in a feature that is not ordinary worksheet formula text, and an identically spelled word could appear for another reason.

If you want to preserve formulas, first update them to use the intended cell references or another valid name. If you are only investigating, make a copy of the workbook and test the deletion there. This is particularly helpful when the name is used across several sheets or by other people.

Hidden, broken, and built-in names

A name whose Refers to field contains #REF! is broken: its reference points to something that no longer exists, often because a referenced sheet or range was removed. If the name is visible in Name Manager and you have confirmed that it is no longer needed, select it and click Delete. The broken name does not usually prevent deletion; the important question is whether some workbook feature still relies on it.

Excel also uses special names for certain features. For example, print areas and print titles are names associated with a worksheet’s page setup. You can inspect these in Name Manager, but it may be clearer to change or remove them through the sheet’s page setup options if your aim is to alter printing. Some names created internally by Excel, filters, macros, or add-ins may be hidden from the usual list. Do not remove unfamiliar entries just because their names look unusual; first determine what created them and whether the workbook depends on them.

If a hidden name appears to be causing a problem, make a backup and ask the workbook’s owner or administrator before using VBA or a third-party cleanup tool. Deleting internal names indiscriminately can disrupt features or add-ins, and a macro-based change cannot be undone with Ctrl+Z.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. On Mac, look for Formulas > Name Manager in the ribbon; keyboard shortcuts and some dialog details differ, so the ribbon path is the dependable route. On Excel for the web, available name-management controls can differ from the desktop application and may depend on the current interface. If you cannot find the needed Name Manager command or cannot remove the entry there, open the workbook in the desktop app and use its Name Manager.

If a file is stored in OneDrive or SharePoint, make sure you have permission to edit it. Also consider whether another person or an automated process is making changes at the same time. After deletion, save the workbook and reopen it if you need to verify that the name has not been recreated.

A safe troubleshooting sequence

For a reliable fix, take these steps in order:

  1. Save a separate copy of the workbook before making a change that could affect formulas or shared work.
  2. Open Formulas > Name Manager and confirm that the selected entry is a defined name, not a table.
  3. Check its scope and Refers to value; look for another entry with the same spelling.
  4. Search formulas and inspect relevant workbook features if the name may be in use.
  5. Delete the confirmed name, save, and check formulas and workbook behavior for errors.
  6. If it returns, investigate macros, add-ins, templates, or other users’ edits instead of deleting it repeatedly.

Keeping the copy also gives you a simple way to recover if the name turns out to support a report, validation list, print setting, or other feature you had not noticed.

Frequently Asked Questions

Can I delete a named range without deleting its cells?
Yes. Deleting a defined name removes the label and its reference, not the cells or their contents. The formulas or features that used the name may still need repair.

Why is the Delete button unavailable in Name Manager?
Confirm that a defined-name entry is selected and that the workbook is editable. If the item is a table name, manage it through Table Design instead. If the workbook is read-only or editing is restricted, use an authorized editable copy.

Why does the name come back after I delete it?
A macro, add-in, template, workbook feature, or another editing process may recreate it. Note when it returns—immediately, after running a command, or after reopening the file—and investigate that trigger.

Will deleting a name break formulas?
It can. Formulas that rely on the removed name may show #NAME?. Search for references and test changes in a copy before deleting a name used by a working model.

Can I delete a table name in Name Manager?
No. A table’s name is managed on the Table Design tab. Rename the table there, or choose Convert to Range if you intend to remove the table structure rather than just its name.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.