Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
with a drop down list in excel how do I select multiple values
I have a validation on one of my columns for Users to select values from a
list in a different worksheet. This works fine, but now the Users need to select multiple values in the one cell. How do you do that? A simple example. Pet Type Dog Retriever, Beagle |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
with a drop down list in excel how do I select multiple values
I think what you need is a dependent DV list.
Select Dog from DV list and a second DV list appears with the Type of dog See Debra Dalgleish's site for instructions. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Thu, 13 Jul 2006 08:57:02 -0700, Keith H <Keith wrote: I have a validation on one of my columns for Users to select values from a list in a different worksheet. This works fine, but now the Users need to select multiple values in the one cell. How do you do that? A simple example. Pet Type Dog Retriever, Beagle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mask Drop Down List values | Excel Discussion (Misc queries) | |||
How do I tie prices to a drop down list of products in excel? | Excel Discussion (Misc queries) | |||
How do I set up a conditional cell from a drop down list in Excel | Excel Worksheet Functions | |||
Get excel to list values that occur within raw data | Excel Discussion (Misc queries) | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions |