View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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