Using Lists in Excel

D

Dmac59_Melbourne

When using Lists in Excel, is it possible to allow multiple selections from
the drop-down list?
 
O

ogerriz

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

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

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

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
 

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

How do I enable multiple selection dropdowns? 2
Data Filter Keystrokes 5
How to create 2 dependent drop down lists from 1 original drop dow 5
Multi Select from Drop List 2
How do I create multi choice selec drop down list in Excel please 7
List the Drop down list from the top 3
not able to assign macro 4
Drop-down lists in Excel 2003 3

Top