| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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! |
|
#2
|
|||
|
|||
|
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! |
|
#3
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Drop down menu | Excel Worksheet Functions | |||
| How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
| Adding a KeyID column for sorting | New Users to Excel | |||
| Adding column data | Excel Worksheet Functions | |||
Linear Mode
