Use data validation. Check out following link for details:

http://www.contextures.com/xlDataVal01.html


"CindyW" wrote in message
...
I have a "request" form set up in excel. I want to be able to make fields
that I can set and store options for and chose the option that I want each
time instead of having to type the data each and every time. For example:

Art Request To: ______________________________

In the blank, I want to be able to choose from the different locations
that
we normally have our art sent to. The information would appear like this:

MaryAnne Smith
ABC Company

Is there a way to create like a "drop down" menu in a cell that allows for
choosing options?

Or perhaps there is a better way? PLEASE HELP!!! I do these things
everyday
and need a better way to do them.