Name Box in MS Excel

[martinjr]

I wand to remove entries that are no longer used from a Name Box - the one that has a drop down box if entries in there. How do I do it? The does not seem to be any help available for this.

[Bushwhacker]

RU talking about a dropdown list in a cell that has several options available when you click on the down arrow ??

[martinjr]

Yes, it's on the extreme left hand side of the toolbar area. If you open a new Excel document it will drop down when you click on the arrow but shows a blank box.

[ChuckFickens]

I think you mean the name box, you can't get rid of it, it's used for naming and selecting ranges of cells on a worksheet

[martinjr]

Yes, I called it Name Box in original question and NO, I don't want to get rid of the box itself -----some of the contents entered earlier by me.

[ChuckFickens]

I do apologise, misread your post, got o insert menu select name and then define and you can select and delete them from there.

[martinjr]

Yes, that's it tahnk you very much. No need for any further replies on subject.