How do I delete or modify an existing drop down list?

  • Thread starter Thread starter Jim Bradley
  • Start date Start date
J

Jim Bradley

I created a drop down list for input validation but need to eother add to the
list or delete the existing list and re-create it. How do I do that?
 
I created a drop down list for input validation but need to eother add tothe
list or delete the existing list and re-create it. How do I do that?
Click to expand...

Jim,
Go to data/validation and chose any value to remove the validation.
If you want to change it to something else then go back to Data/
Validation and chose another validation and or List.
Jay
 
You're the person who created the DV dropdown list so you should know what
the list is comprised of.

Is it a range of cells or a comma-delimited list?

In either case, re-define the range or delete from the comma-delimited list.


Gord Dibben MS Excel MVP

On Tue, 4 Nov 2008 08:05:01 -0800, Jim Bradley <Jim
 
You must log in or register to reply here.

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Filtered drop down list 2
lost the drop down list (the validation still exist) 4
Drop Down List Contains the List Header Row 1
modify drop down list 1
Drop down list 2
Position of a drop-down list 5
How to delete a drop down box in Excel 2007 1

Back
Top