Insert a Checkbox in a Cell in Excel

There are virtually limitless possibilities and options for which you can use Excel. One of these options is to add a checkbox to a certain cell.

We will show how to do that in the example below.

Put Checkbox in a Cell

For our example, we will presume that we have a lazy kid which was given a task to buy groceries:

Graphical user interface, application, table, Excel

Description automatically generated

In column B, we will place our checkboxes to verify if some of these groceries have been bought or not.

To achieve this, the first thing that we need to do is enable the Developer tab in our Ribbon. We will right-click anywhere on the ribbon, then choose the Customize the Ribbon option:

Graphical user interface, application

Description automatically generated

On a pop-up window that appears, we will simply click the checkbox for the Developer tab:

Graphical user interface, application

Description automatically generated

Now that we have a developer tab in the ribbon, we would go to it, and then choose: Controls >> Insert >> Form Controls >> Check Box:

Graphical user interface, application, table, Excel

Description automatically generated

When we click here, we will have a little cross symbol that is usually used for drawing in Excel. We will draw our checkbox in cell B2 and it will look like this:

Graphical user interface, application, table

Description automatically generated with medium confidence

To edit the checkboxes, we have to right-click on the boxes.

To copy and paste the checkbox till the end of our range, we need to select the cell that has a checkbox by coming to it with arrow keys on the keyboard, and we need to position our cursor over the lower right corner of our cell. We will then drag the pointer once we see a black cross.

This is our result:

Table

Description automatically generated

We can also link our checkboxes to a certain cell. We will right-click on the first checkbox and then choose Format Control:

Graphical user interface, application

Description automatically generated

On a window that appears, we will go to the Control tab and input the desired cell in the Cell link option (cell C2 in our example):

Graphical user interface, application

Description automatically generated

We will select some of the checkboxes, including the one we linked to a cell, and this is our result:

Table

Description automatically generated