How can I use like a mail merge feature in excel to create a form

[Guest]

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.

 

[Shatin]

Use data validation. Check out following link for details:

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

 

[Guest]

Is there a way that if I choose 1 option in the first field that it will
automatically choose other options for me?

Such as:

Fruit: Cherries
Color: Red
core: Yes
Vine/tree: vine

I want to be able to pick cherries and then possibly have the other options
filled in based on my 1st choice. Can this be done?

 

[Shatin]

Yes, by creating a lookup table.

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