Adding a Drop down menu to a column

[Stacy]

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!

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Stacy]

Thank you!!!!

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

www.OfficeArticles.com
www.MyExpertsOnline.com