how do i create drop down menu in excel

[ezeflier]

I would like to have a dropdown menu work in excel as it does in Word. (Not
using a Vlook up.) Is this possible?

 

[CyberPhix]

Goto Data and Validation from Excel's menu.

Under the Allow Drop down, choose List, Select the Range
where you have your list to be in the drop down box.

 

[Brett Patterson]

Here's what I did to create 3 separate drop-downs in one form.

On a new worksheet I put values (including headers) into 3 different columns:
[Delivery Method] | [Type of Mail] | [Status]
UPS | Letter | Awaiting Pickup
USPS | Box | Picked Up
Other | Campus Mail |
| Other |

Then, select the VALUES ONLY of the list (so Awaiting Pickup) and in the top
left corner, under the toolbar buttons click the Cell Number that show up
(it's to the left of the fx box). Rename it to something (One word is
better: "Status").

Do the same for the others.

Select everything you want to be the list (including the headers/titles.
i.e.: Status, Awaiting Pickup, Picked Up) and when they are all selected
right click on them, select "List --> Create List". Leave the selection the
same, check "My List Has Headers".

Do the same for the others

Go back to the worksheet where you want your list to show up.

Select the cell(s) where you want the same list to show up. Go to
"Data-->Verification" and from the dropdown menu choose "List", uncheck the
"Ignore Blank" box if you require an input value. In the input box, type:
=Status
or the = sign followed by whatever your list name was that you entered
earlier (the input to the left of the fx input box, in my example it was
Status).

Hope this helps you.

~Brett Patterson
=====================================================