Drop downs & lists

[seahawk56]

I'm really not sure what to call them since I'm not very good with my excel terminology. I'm creating a survey and for some of the questions I would like to have a "drop down box" so they can choose the appropriate answer. Similar to if you were filling out information on a web site and you get to the State you live in. "Select" would be the only thing you would see and then when you clicked on it you can choose from all the states. Sorry if this sounds confusing but I sure hope someone knows what I'm talking about.

 

[roentgen]

Create a list of what is required in the dropdown.

In the cell you require the dropdown, go to the top menu : Data then Validation.

In the Allow section, select List and complete the source data field with your list.

With OK, the dropdown should appear when the cell is selected.

Good Luck

 

[seahawk56]

Thank you very much! It is almost frustrating now knowing how easy it actually was.