Hi Megs,
Make a list of what you would like to be able to choose in an unused part of
your worksheet. Enter only one "answer" in each cell. Now highlight the
cells that you would like to have the drop down appear, click on data, then
click on validation. In the validation criteria drop down, choose "list". In
the source area, click on the worksheet icon to the right, it will take you
back to your worksheet, now highlight the cells that contain your answers &
press enter. Now when you click in the cell, a drop down will appear for you
to choose your answer from. You can also set a customized input data message
& alert in case someone tries to enter data other than what is in your
"list", do this under the second two tabs in the validation screen.

Hope this helps

"megs" wrote:

I am making a survey and I need to have drop down boxes where more than one
answer can be chosen. Is this possible. If so how do I do it?