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

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?
 
J

jlclyde

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
 
G

Gord Dibben

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
 
Top