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
|