Forum Discussion
Excel drop down list
Does the excel drop down feature only allow the user to select one choice or can multiple drop down options be selected? If it is limited to once choice but I want multiple choices, is it just better to format the choices into columns for data abstraction?
Thanks,
Maria
2 Replies
- Excel drop down allows 1 selection. If you insert 'form control' or 'ActiveX control' there are some multi-select options but I don't think they will spit out the multi-selections to a cell (i.e. you need a macro behind it to do that). that said if you know you want the user to select x number of items you can create x number of drop downs. you can even get fancy and have custom list locations to exclude duplicate selections.
Another alternative is to not use drop downs but a list with a 2nd column and have the user enter an 'X' for their selections. There is no built-in option for selecting multiple items, but it can be done with a bit of VBA - see Excel Data Validation - Select Multiple Items
