Excel Named Range Won’t Delete? Causes and Fixes to Try

How-to basics · Updated November 19, 2026

No—Excel can delete most named ranges, which it calls defined names. In Excel for Microsoft 365 on Windows, press Ctrl+F3, select the name in Name Manager, and choose Delete; if that option is missing or disabled, first check the name’s scope and whether it is actually a table name or another special item.

What a named range is—and what it is not

A defined name is a label attached to a cell, range, constant, or formula. For example, a workbook might define TaxRate as a cell containing a rate, or QuarterSales as the range B2:B5. Formulas can then use the label rather than a cell address. You can inspect a name’s target in the Refers To column of Name Manager.

Names can have workbook scope or worksheet scope. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is specific to one sheet and can coexist with a workbook-scoped name of the same spelling. The Scope column identifies which kind you are looking at. This distinction matters when troubleshooting: a name you see on one sheet may not be the same name that a formula uses elsewhere.

Not everything that looks like a name is a defined name. Excel tables have their own names, and chart titles, cell text, and sheet names are different objects. Name Manager is for defined names; deleting an entry there will not remove a table or erase the cells to which a name refers.

Delete a defined name in Name Manager

On Windows, open Formulas > Name Manager, or press Ctrl+F3. Locate the row, check its Scope and Refers To details, select it, and choose Delete. Confirm the action if Excel asks. The name is removed from the workbook, but the cells and their contents remain unchanged.

  • If the list is long, use the Filter control in Name Manager to narrow the displayed names, such as by scope or whether a name has an error.
  • For a worksheet-scoped name, check the sheet shown in the Scope column before deleting. Do not assume that two identical-looking names are interchangeable.
  • If you are unsure what a name supports, copy its name and Refers To value somewhere safe before removing it.

In Excel for Mac, open Formulas > Name Manager and select the defined name to remove it; the menu path is the practical equivalent of the Windows shortcut. In Excel for the web, name-management options can be more limited than in desktop Excel. If the relevant manager or Delete command is not available in your web session, open the workbook in the desktop app and make the change there.

Why Delete may seem unavailable

Often, the problem is not that Excel forbids deletion but that the target has been misidentified or is not visible in the current list. Work through these checks before changing workbook settings:

  • Check the filter. A filter in Name Manager may hide names outside the selected category. Clear or change it, then look again.
  • Check scope. A local name belongs to a particular worksheet. Review the Scope column and select the exact entry you intend to remove.
  • Check that you selected a row. The Delete command is used on a selected name in the list; clicking in another part of the dialog may leave the command unavailable.
  • Check whether the workbook is editable. Read-only access, a file opened in Protected View, or restrictions on editing can prevent changes from being saved. Use an editable copy or ask the workbook owner for permission.
  • Check for special names or hidden entries. Some names are created for Excel features, and certain legacy or programmatically created names may not appear like ordinary user-defined names.

Worksheet protection is generally about editing cells and other sheet content, while workbook-structure protection controls actions such as adding, deleting, or moving sheets. Neither is a general-purpose lock on every defined name. If Delete is disabled, do not assume that unprotecting a sheet is the solution; first confirm that the workbook is editable and that the selected item is an ordinary defined name.

Check what formulas and features use the name

Excel may let you delete a name even when formulas refer to it. That does not make deletion harmless. A formula that depends on the removed name can return #NAME?, because Excel can no longer resolve the label. For example, if a formula uses =SUM(QuarterSales) and you delete the workbook-scoped name QuarterSales, that formula may stop calculating correctly.

Before removing an unfamiliar name, search the workbook for its spelling. Press Ctrl+F on Windows, open the Find options, and set Look in to Formulas; on Mac, use Command+F and the equivalent search options. Search results are clues, not a complete dependency report. A short name can match unrelated text, and references may occur in places that a simple worksheet search does not make obvious, including chart series, data validation, conditional formatting, or other defined names.

After deletion, inspect formulas and workbook features that might have relied on it. If a formula now shows #NAME?, restore the name or revise the formula to use the intended cell reference or a valid replacement name. If the workbook is important, save a separate copy before making a broad cleanup; deleting a name is not reliably reversible after you close the file.

Tables, print areas, and other special cases

A table name is not an ordinary defined name. When you select a table, Excel shows the Table Design tab, where its name appears in the Table Name box. You cannot remove that required table identifier through Name Manager while keeping the table intact. You can rename it there, or use Table Design > Convert to Range if you want to keep the cell data but stop using table features. Converting changes the object; it is not the same as deleting the table’s data.

Print areas are another common source of confusion. Excel stores a print area as a special, sheet-specific name, often displayed as Print_Area. To clear the print-area setting, select the relevant sheet and use Page Layout > Print Area > Clear Print Area. Deleting the special name directly may work, but using the print-area command makes the intention clearer. If a print area is set again later, Excel can create the name again.

Excel also uses names for some legacy or feature-related purposes. Entries beginning with an underscore or showing an error in Refers To may have been created by Excel, an add-in, or an older workbook process. Do not delete these just because they look unfamiliar: identify their purpose first, especially in a workbook that uses filters, print settings, or automated reporting.

Hidden names and names that return errors

Some workbooks contain defined names that are hidden from the usual Name Manager list, for example names created by a macro or an older application. If a name appears in a formula or a warning but cannot be found in Name Manager, a hidden name is one possibility. It is also possible that you are looking at a table name, a different worksheet scope, or a different copy of the workbook.

For names that show #REF! in Refers To, the name points to a reference that no longer exists or has become invalid. An error does not automatically mean that the name is safe to remove: check whether formulas still use it and whether a workbook feature depends on it. If a hidden name must be inspected, ask the workbook’s owner or a knowledgeable Excel developer to review it. Avoid running a macro that deletes every hidden name; that could remove names an automated process needs.

A careful cleanup process

When the goal is to tidy a workbook rather than fix one specific name, use a repeatable process. First save a copy, then review names one by one in Name Manager. Record the scope and Refers To value for anything unclear, and distinguish ordinary defined names from table names and feature-related names. Search for likely formula references, but treat search as a check rather than proof that a name is unused.

After removing a name, recalculate if necessary and review key sheets, formulas, charts, validation lists, and print settings. Look for #NAME? errors and unexpected changes. If the workbook is shared or used for reporting, tell other users what changed; someone else may rely on a name that is not obvious from the visible cells. Keeping meaningful names and deleting only confirmed leftovers is safer than trying to remove every unfamiliar entry.

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 values. The cells remain where they are.

Why is Delete greyed out in Name Manager?
Check that you selected a row in the list, clear any filter that might obscure the target, and confirm it is a defined name rather than a table name. Also check whether the workbook is open read-only or editing is restricted.

Will deleting a name break formulas?
It can. Formulas that use the deleted name may return #NAME?. Search for references and review the workbook after deletion; a search alone may not find every use in charts or formatting rules.

How do I remove a table name in Excel?
Select a cell in the table and use Table Design > Table Name to give it a different name. If you want to stop using the table object, choose Table Design > Convert to Range; this retains the cell contents but removes table behavior.

Can I delete a name that refers to #REF!?
Usually you can remove an ordinary defined name with an invalid reference, but first check whether anything still uses it. If its purpose is unclear or it is hidden, get the workbook owner or a developer to identify it before cleanup.

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.