Creating drop down lists with multiple options?

  • Thread starter Thread starter acf33
  • Start date Start date
A

acf33

I am trying in vain to create a drop down list where users can select more
than 1 choice. For example, if the choices in a list which i named are as
follows:

Blue
Red
Green
Yellow
Purple

How does one have the option to select any of the colors by themselves or
any combination of all of them up? For example, if the question is what is
your favorite color? How can a user choose Blue OR Red and Blue OR Red, Blue
and Green and so on?

Any help would be appreciated.
 
That will require multiple cells. One cell will only hold 1 value. Any single
cell solutions are going to be more complicated than it is worth.
 
so i can't create a drop down with check boxes and allow more than one choice
or it becomes an exercise in reprogramming excel (which im not capable of)?
i'm trying to organize a decent amount of data and do it correctly from the
outset.
 
Back
Top