Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding a Drop Down List 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
|
|||
|
|||
use data validation - it will restrict the entries to items that are validated. if you use the List option you can refer to a list of the two options in another part of the spreadsheeet. Once data validations is set up when you go to the cell you will see the drop down arrow on the right. Ruth -- Ruthki ------------------------------------------------------------------------ Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503 View this thread: http://www.excelforum.com/showthread...hreadid=383572 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a Drop down menu to a column | Excel Discussion (Misc queries) | |||
Text to Columns from drop down list update | Excel Discussion (Misc queries) | |||
drop down list multiple columns | Excel Discussion (Misc queries) | |||
How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Drop List Referencing | Excel Worksheet Functions |