Inserting A Check Box In Excel

Here is a quick description of how to insert a check box into an Excel worksheet and some of the simple things you can do with that:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

First, you need to make sure you have the Developer tab on your Ribbon. If not, go to:
File => Options => Customize Ribbon and make sure the Developer box is checked:


Next, go to the Developer tab and click on Insert, and then click on the check box item in the Form Controls section:


Now you can drag the check box where ever you want it to be on your worksheet. You can then also highlight the text and rename the check box.

Next, right click on the check box and select Format Control:


Here is where you can tie the check box to another cell. Here I’ve chosen to tie it to C7:


Now you can incorporate it into other formulas in your worksheet:


Note in cell C9 I multiplied C7*1 to convert TRUE to a one or FALSE to a zero. To learn more about that, see a very recent post I did on this topic here.

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

No comments yet.

Leave a Reply