Deleting a Range Name in Excel 2007

To delete a range Name:

1. Select Formulas -> Name manager.
Press Ctrl+F3.
2. Select the Name, and then click Delete.

7 thoughts on “Deleting a Range Name in Excel 2007

  1. “Hi,
    Thanks for your tips. However, do you know how we can batch-delete the unused (or mis-referring) names in a workbook?
    Thanks again.

  2. “Consider the Following code to batch-delete the unused names in a workbook.
    Dim i As Integer
    For i = 1 To ActiveWorkbook.Names.Count
    Next i “

  3. If anyone uses ASAP utilities (personally I can’t live without it) there is a list all range names function that lists all range names on a new worksheet.Even after deleting all range names in INSERT/DEFINE/DELETE menu it still lists them all. Is this a problem with ASAP or are they still really there?

  4. “Hi Paul,
    Sounds like a bug in that application to me. BTW, not sure if you have a different version of Excel to me, but try checking under INSERT – NAMES – DEFINE too.

  5. Thanks (again) Alan, the only thing that worries me is that after the file has been saved, my computer shut down & restarted, it still produces a completely fresh listing with the range names on. Also I’ve noticed that in the define names menu (it is the same place as yours, I got it wrong, Xl2K on WinXp for reference) when you click the help “?” in the corner then click the delete key it says it deletes it from the range names in workbook “list” not that it is actually deleting the naming of the range. I’m wondering if it remains in the etherea of Excel.

  6. “Hi Paul,
    Mobile – that’s me! You could be right. I’ve never run into this before. Is there a dicussion or feedback facility with ASAP? If so, you might want to try them, and then enlighten us back here if you find out what is happening? Interesting that the names might still be there hidden away. Kind of similar to Word with the edits history and hidden text issue perhaps?

  7. Hi
    It might not be a bug of ASAP. If I create a named range. afterwards create a table, delete named range and try to rename the table with the name previously used for the named range, excel replies that the name is already in use. so the delete doesn’t fully work.

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 7 = eleven

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>