If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simple Yes/No drop down box
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it. Thanks |
#2
|
|||
|
|||
Simple Yes/No drop down box
Select the cell and then click on Data | Data Validation. In the
dialogue box for Allow click on List, and then in Source you can type "Yes,No" (without the quotes) and ensure that In-cell drop-down is checked. Click OK and then you have it. Hope this helps. Pete On Apr 21, 9:41*am, Debi wrote: Hi, I am looking to create a simple drop down box which has yes or no as the options. For the life of me i can't remember how to do it. Thanks |
#3
|
|||
|
|||
Simple Yes/No drop down box
--From menu DataValidation
--In settings tab for Validation Critiera select 'List' --Type as below and hit OK Yes,No OR refer a range as which contains Yes and No =$A$1:$A$2 -- Jacob (MVP - Excel) "Debi" wrote: Hi, I am looking to create a simple drop down box which has yes or no as the options. For the life of me i can't remember how to do it. Thanks |
Thread Tools | |
Display Modes | |
|
|