Deleting many named ranges

[Tom Hayakawa]

I have a spreadsheet that has a couple of hundred named ranges in it that I
need to delete. Is there an easy way to do this or am I stuck in the Define
Name box deleting them one by one? Thanks in advance for any guidance.

 

[Debra Dalgleish]

If you're working with names, you might like the Name Manager, a free
add-in that makes it easy to work with defined names. You can download a
copy:

http://www.bmsltd.ie/MVP/Default.htm

It allows you select and delete multiple names

 

[Tom Hayakawa]

Debra,

Thanks for the tip. That worked perfectly.