How do I create a multiselect drop down list

Y

Yve

I have drop down lists in my worksheet - I now need to make multiple
selections in some cells (each separated by a semicolon). Thx.
 
B

Bernie Deitrick

Yve,

If you want to do that, they must be included in the list as options.

Otherwise, use multiple cells and concatenate the values into one string.

HTH,
Bernie
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

Formatted cell column in drop down list 1
drop down lists 1
Values from 3 separate drop-down lists entered into single cell 4
Drop down lists on multiple worksheets 2
Data Validation List Names 2
Drop Down with dynamic named range offsheet source list 14
Drop Down Lists 2
How do i create a drop down list from information on another works 2

Top