Allow for multiple selections from a list

D

Doug

I am trying to allow for multiple selections from a drop down list...how can
I accomplish this?

Thanks
 
R

Raz

First create a list of selections somewhere in the worksheet.
then select the cell you wish to have the drop down list.
then go to Data tab, Data Validation, select List
then click on the red arrow below the word 'source' and select your list
created previously. and click OK. you r done
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple selections from a drop down list in Excel... 3
Drop Down lists and condtional formating 2
Multiple selections in a drop down menu 2
How do I create a multiselect drop down list 2
Drop Down Lists 2
Formula for totaling selections 6
Using Lists in Excel 4
How do create a drop down list and then make multiple selections? 1

Top