How to Add a Yes or No Box to an Excel Spreadsheet

Display the Developer Tab
1. Click the 'File' tab and click 'Options.'
2. Click 'Customize Ribbon' and click 'Main Tabs.'
3. Check the box labeled 'Developer' and click 'OK.' The Developer tab appears in the Excel ribbon.
Yes or No Option Button
4. Open the Excel spreadsheet that you want to add an options button.
5. Click the 'Developer' tab and click 'Insert' from the 'Controls' group.
6. Click 'Option Button' under the 'Form Controls' heading.
7. Click the cell in which you want to insert the options button.
8. Highlight the words 'Options Button 1' on the options box. Type 'Yes' and click on an empty cell in your worksheet.
9. Click 'Option Button' under the 'Form Controls' heading.
10. Click the cell in which you want to insert the second options button.
11. Highlight the words 'Options Button 2' on the options box. Type 'No' and click on an empty cell in your worksheet.
12. Right-click an options button and click 'Format Control' to edit the button's color, format, size or any other properties. Click 'OK.'
Yes or No Check Box
13. Open the Excel spreadsheet that you want to add a check box.
14. Click the 'Developer' tab and click 'Insert' from the 'Controls' group.
15. Click 'Check Box' under the 'ActiveX Controls' heading.
16. Click the cell that you want to insert the check box. This cell will include the upper left corner of the check box.
17. Highlight the words 'Check Box 1' on the check box. Type 'Yes' and click on an empty cell in your worksheet.
18. Click 'Check Box' under the 'ActiveX Controls' heading.
19. Click the cell that you want to insert the second check box.
20. Highlight the words 'Check Box 2' on the check box. Type 'No' and click on an empty cell in your worksheet.
21. Right-click a checkbox and click 'Format Control' to edit the check box's color, format, size or any other properties. Click 'OK.'