Here is how to quickly set the cells in a column to a Yes/No combo/drop box without using Excel forms:
1) Select the column
2) Go to Data menu and choose Validation
3) Change the "Allow" drop box to "List"
4) In the "Source" box enter the text "Yes,No" (without quotes)
5) Click OK