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:

check1

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

check2

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:

check3

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

check4

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

check5

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!

Related Post

Free Download!

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

, , ,

No comments yet.

Leave a Reply