Two ideas: You can either use multiple columns, and have user pick different
answers in each column, or you could use a list box (from Forms toolbar).
Under format contol, select the option to allow multiple selections (either
"multi" or "extend".)

The bigger question is how is the data from this dropdown to be user? If it
is to simply be displayed, you have numerous choices. If it's supposed to be
fed into some type of data analysis, then you need to keep 1 data point in
each cell.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MaryAM" wrote:

A client of mine wants to include a drop-down list in Excel. The twist is
that she'd also like people to be able to choose more than one item from the
list in response to a question. For example, if people are asked why they
like bread, they can choose one or more answers from a list with tasty,
chewy, soft, nutritious. Can this be done in Excel? If so, how? Thanks!