Using Lists in Excel
 

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

Using Lists in Excel
 

Please explain???

Do you mean like a check box where you can select between 1 and all of the
items on the list?

"Dmac59_Melbourne" wrote:

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

Using Lists in Excel
 

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.

"ogerriz" wrote:

Please explain???

Do you mean like a check box where you can select between 1 and all of the
items on the list?

"Dmac59_Melbourne" wrote:

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

Using Lists in Excel
 

Hi
Take a look at the Custom function in the dropdown.
You could have Begins with "C" OR Begins with "J" for example.

--
Regards
Roger Govier

"Dmac59_Melbourne" wrote in
message ...
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.

"ogerriz" wrote:

Please explain???

Do you mean like a check box where you can select between 1 and all of
the
items on the list?

"Dmac59_Melbourne" wrote:

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

Using Lists in Excel
 

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



On Wed, 15 Apr 2009 22:36:01 -0700, Dmac59_Melbourne
wrote:

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.

"ogerriz" wrote:

Please explain???

Do you mean like a check box where you can select between 1 and all of the
items on the list?

"Dmac59_Melbourne" wrote:

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