Forum Discussion
How to select multiple items in a drop-down list
I am trying to give users of my spreadsheet the option to choose multiple selections from a drop-down menu. I have all State abbreviations and want them to be able to choose one or more states that a...
JLSantiago Quick question with regard to your application - is there a need for a drop-down list, or is this something that could be accomplished using a slicer?
If you are filtering data in a table, then it would be a lot easier to manage using a slicer as opposed to using cell validation / dropdowns.
macrordinary My coworker has figured out how to accomplish this and will show me how he did it so I can apply this to other workbooks. Thank you