MrExcel Publishing
Your One Stop for Excel Tips & Solutions

(Yes/NO) check boxes in Excel cells?

Posted by Kevin Mac on January 04, 2002 10:12 AM

I am looking to see if there is a way to insert "yes/no" check boxes into an Excel worksheet in a particular column. In this case the column is I2:I60. Thanks

Posted by Russell Hauf on January 04, 2002 11:05 AM

You'll have to insert them manually with either the Forms toolbar or the Control Toolbox toolbar (they are different, so be careful. The checkbox on the Forms toolbar is easier to use, but is limited in what you can do with it. The one on the Control Toolbox can do much more).

Hope this helps,


Posted by Joe Was on January 04, 2002 11:10 AM

Do you want the text in cells or do you want to know how to use a controle check box, User Form CheckBox or workSheet Form CheckBox. As you can see you have choices?

To put a dropdown list in cells, users can then select, in your case "Yes or No" from a dropdown and not type the text. Use "Data Validation" select list and enter Yes,No

To use Control checkbox select View-ToolBars select Control, than drag a checkBox to your location on the screen. Do the same for the forms toolBar, not you will need to write code to do or put information once the box is checked.

The user form check box is done from the Visual Basic editor but works much the same way.

More Info please! JSW

Posted by Keivn Mac on January 04, 2002 11:51 AM


Either of the options you fellows mentioned will suit my needs, so I appreciate the input. I should have known that actually, but as always, it is so easy to overlook the obvious. Thanks as always for the great information.

Posted by Tanya on January 04, 2002 12:15 PM

If you are going to put a checkbox in each cell in column I, then you would be better off using data validation instead of the checkbox. The form controls were really meant for creating forms, and used in the manner that you describe, will really bog down your computer if Excel resides locally. I learned this the hard way, and I put a bunch of checkboxes in a column, about a 100 or so, and it took 5+ minutes for the file to open.