Forget using developer mode; add one or more checkboxes to your Excel file with just one click.

Before, to add a checkbox in an Excel file, you had to go through the developer tab and configure this checkbox.

Add a checkbox

It is now possible to add checkboxes in 1 click. To do this, select the cell where you want to add a checkbox. Then, go to the Insert menu. In the Controls section, click Checkbox.

A check box is inserted into the cell and gives a value to the cell. Indeed, if the box is not checked, the value is false.

However, if the box is checked, the value of the cell is true.

So you can use these cells in IF formulas (if, countif, etc.).

Add and manage multiple checkboxes at the same time

Add multiple checkboxes at once

It is possible to add several checkboxes at once. Select a range of cells, then click Checkbox on the Insert menu. This will add a checkbox to all selected cells.

You can also pull the handle of the cell, this will add a checkbox in the new cells.

Check or uncheck multiple boxes at the same time

SPACE

To check and uncheck several boxes at once, select the different cells and then press the SPACE key on your keyboard. All selected cells will be checked or unchecked at the same time.