When using Lists in Excel, is it possible to allow multiple selections from the drop-down list?
D Dmac59_Melbourne Apr 16, 2009 #1 When using Lists in Excel, is it possible to allow multiple selections from the drop-down list?
O ogerriz Apr 16, 2009 #2 Please explain??? Do you mean like a check box where you can select between 1 and all of the items on the list?
Please explain??? Do you mean like a check box where you can select between 1 and all of the items on the list?
D Dmac59_Melbourne Apr 16, 2009 #3 The Drop-down list contains say 20 names - I can only select one name from the list, which populates the cell. I want to select multiple entries.
The Drop-down list contains say 20 names - I can only select one name from the list, which populates the cell. I want to select multiple entries.
R Roger Govier Apr 16, 2009 #4 Hi Take a look at the Custom function in the dropdown. You could have Begins with "C" OR Begins with "J" for example.
Hi Take a look at the Custom function in the dropdown. You could have Begins with "C" OR Begins with "J" for example.
G Gord Dibben Apr 16, 2009 #5 Using Data Validation dropdown list.................yes. Download a sample workbook from Debra Dalgleish's site. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. As written it creates a comma delimited list of selected entries. Gord Dibben MS Excel MVP
Using Data Validation dropdown list.................yes. Download a sample workbook from Debra Dalgleish's site. http://www.contextures.on.ca/excelfiles.html#DV0017 Note that you can have the selections in an adjacent cell or in the same cell. As written it creates a comma delimited list of selected entries. Gord Dibben MS Excel MVP