Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pulldown boxes
You can use Data Validation:
1. Select the cell(s) in which you want the list 2. Choose DataValidation. 3. From the Allow drop-down list, choose List 4. In the Source box, type: Yes, No 5. Click OK. Note: Users will be required to match the case in the list, (e.g. "no" will be an invalid entry because of the lower case letters) You can also refer to a list on worksheet, which is not case sensitive. There are some instructions he http://www.contextures.com/xlDataVal01.html david wrote: I was wondering if it was possible to make a pulldown in a cell. So, that I could make them select from the pulldown menu choices. For example in a certain cell, I just want them to select yes or no. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulldown that searches? | Excel Discussion (Misc queries) | |||
Help with hyperlinks in pulldown list. Anyone know how? | Excel Worksheet Functions | |||
Data Entry Using Pulldown | Excel Worksheet Functions | |||
can I make pulldown text boxes in excel sheets | Excel Discussion (Misc queries) | |||
pulldown boxes | Excel Programming |