| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete or modify an existing drop down list?
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete or modify an existing drop down list?
On Nov 4, 10:05*am, Jim Bradley <Jim
wrote: 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? 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I delete or modify an existing drop down list?
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 wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I delete existing data from a drop down menu list? | Excel Worksheet Functions | |||
| Use existing table to populate a drop down list & create a new tab | Excel Discussion (Misc queries) | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| How do i add a new entry to an existing drop-down list in Excel? | Excel Worksheet Functions | |||
| Adding items on an existing drop-down list | Excel Discussion (Misc queries) | |||
Linear Mode
