Adding a Drop down menu to a column
 

Hello!

Can anyone tell me how to add a drop down list to a specific column? I need
to have only two options in the list, and the people using the spreadsheet
should not be able to input any other value than:

Local Market
Other

Thanks!

Hi, Stacy. Try this:
http://www.officearticles.com/excel/...soft_excel.htm
You can just type your two values in.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Stacy" wrote in message
...
Hello!

Can anyone tell me how to add a drop down list to a specific column? I
need
to have only two options in the list, and the people using the spreadsheet
should not be able to input any other value than:

Local Market
Other

Thanks!

Thank you!!!!

"Anne Troy" wrote:

Hi, Stacy. Try this:
http://www.officearticles.com/excel/...soft_excel.htm
You can just type your two values in.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Stacy" wrote in message
...
Hello!

Can anyone tell me how to add a drop down list to a specific column? I
need
to have only two options in the list, and the people using the spreadsheet
should not be able to input any other value than:

Local Market
Other

Thanks!