deleting names from the name box

[Amy C]

How do I remove a name from the name box?

 

[Ron Coderre]

Try this:

<insert><name><define>
Select the name to be deleted from the "Names in workbook" list
Click the [Delete] button

(repeat for each name to be deleted)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Bob Phillips]

Menu Insert>Name>Define..., select the name, and hit Delete.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Amy C]

FABULOUS! That works! Thanks!! Now, I can clean up my spreadsheet.
Have a great day!

Try this:

<insert><name><define>
Select the name to be deleted from the "Names in workbook" list
Click the [Delete] button

(repeat for each name to be deleted)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

How do I remove a name from the name box?

 

[Bob Phillips]

If you have a lot of cleaning to do, invest in Jan Karel Pieterse's utility
designed to improve working with defined names.
It is a free add-in, and you can get it at
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

FABULOUS! That works! Thanks!! Now, I can clean up my spreadsheet.
Have a great day!

Try this:

<insert><name><define>
Select the name to be deleted from the "Names in workbook" list
Click the [Delete] button

(repeat for each name to be deleted)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

How do I remove a name from the name box?