Named data validation list- how to undo?

R

Roady

Hi:

I have created long lists of data that I have "named" as Validation lists. I
want to be able to delete their naming and start over with new naming without
copying/pasting the data into new cells and deleting the old cells. Is there
anyway to keep the data/formulas currently in the lists exactly where they
are and remove the "naming" that I have applied to them to be used in data
validation lists? I have Excel 2003. Happy Friday all!
Thank you!
Roady
 
M

muddan madhu

go to insert | name | define | select the named range and modify as
you want |
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filesize: embedded data validation lists all stored independently? 2
Changing named Validation list to Dynamic list. 1
How do I change the text colour in a drop down list? 1
Data Validation Dropdown List Not Working 4
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Update Excel Data List for Drop Down use 2
Excel 2003 Data Validation 2
Data Validation list search 2

Top