Delete a defined name through the Name Manager

Open the workbook that contains the defined name you want to remove. Go to the Formulas tab at the top of the ribbon, then click Name Manager — it's in the Defined Names group on the left side. A dialog box will open showing every defined name in your workbook.

Find the name you want to delete in the list. Click it once to select it, then click the Delete button. Excel will ask you to confirm the deletion. Click OK, and the name is gone. Close the Name Manager dialog when you're done.

That's the only method you need. The Name Manager is where Excel stores all defined names, and deleting from there removes it completely from the workbook.

Key Takeaways

  • Defined names are deleted through the Name Manager on the Formulas tab, not by editing cells or formulas.
  • Deleting a defined name does not change any cells — it only removes the name itself from the workbook's name list.
  • If a formula uses the deleted name, that formula will show a #NAME? error after deletion.
  • You can delete multiple names at once by selecting each one while holding Ctrl, then clicking Delete once.

What happens to formulas that use the deleted name

If you delete a defined name that one or more formulas are using, those formulas will break. They'll display #NAME? as the result, which tells you Excel doesn't recognize the name anymore.

Before you delete a defined name, search your workbook to see where it's being used. In the Name Manager, click the name and look at the "Refers to" field — that shows what range or value it points to. Then use Ctrl+H (Find & Replace) to search the workbook for that name and see which cells contain it. If you find formulas using it, you have two choices: update those formulas to use the range directly instead, or keep the defined name.

Deleting a name that refers to a range you still need

Deleting a defined name does not delete the cells it refers to. If you have a defined name called SalesData that points to cells A1:A100, deleting the name leaves those cells untouched. The data stays where it is.

The only thing that changes is that you can no longer type SalesData into a formula and have Excel understand it. Any formula that was using SalesData will show an error. If you want to keep using that range but just want to rename it, don't delete it — instead, right-click the name in the Name Manager and choose Edit, then change the name to something new.

Deleting names you created by mistake

If you created a defined name and now realize you don't need it, the Name Manager is the place to clean it up. Open Name Manager, find the name, select it, and click Delete. There's no undo after you confirm, so make sure you're deleting the right one — the "Refers to" field shows you exactly what range or value it points to, so you can double-check before you delete.

If you accidentally delete a name you needed, you can undo it when ready with Ctrl+Z, but only if you haven't closed the workbook. Once you close and reopen the file, the deletion is permanent.

Deleting names created by other people or imported from another file

When you open a workbook someone else created, or when you import data from another file, that workbook may contain defined names you don't recognize. These show up in the Name Manager just like names you created yourself. You can delete them the same way — select the name and click Delete.

Before you delete an unfamiliar name, check the "Refers to" field to understand what it points to. Some names are used by formulas throughout the workbook, and deleting them will break those formulas. If you're not sure whether a name is being used, use Find & Replace to search for it first.

Cleaning up many defined names at once

If your workbook has accumulated many defined names and you want to remove several, you don't have to delete them one at a time. In the Name Manager, hold down Ctrl and click each name you want to delete. They'll all highlight. Then click the Delete button once, and Excel will remove all of them together.

This is faster than deleting individually, but be careful — make sure you've selected only the names you actually want gone. You can't undo a multi-delete as easily as a single one, so take a moment to verify your selection before you click Delete.

Frequently Asked Questions

Will deleting a defined name affect my spreadsheet data?

No. Deleting a defined name only removes the name from Excel's name list. The cells and data the name referred to stay exactly where they are. The only problem is if a formula was using that name — that formula will show #NAME? error.

Can I undo a deleted defined name?

Yes, but only when ready. Press Ctrl+Z right after you delete it, and the name comes back. Once you close the workbook without saving, or save and close, the deletion is permanent and can't be undone.

What does #NAME? error mean after I delete a name?

It means a formula is trying to use a defined name that no longer exists. Find that formula and either delete it, or change it to reference the cells directly instead of using the name.

How do I know if a defined name is being used anywhere?

Use Find & Replace (Ctrl+H) to search for the name in your workbook. Type the name in the Find field and click Find All. Excel will show you every cell that contains it. If nothing shows up, the name isn't being used.

Can I rename a defined name instead of deleting it?

Yes. In the Name Manager, click the name you want to rename, then click Edit. Change the name to whatever you want and click OK. This keeps all formulas using that name working — they automatically use the new name.