Insert a Checkbox in Excel
Inserting a checkbox in Excel is very easy. The checkbox control is available in the Excel developer tools option. Checkbox can be very helpful while designing forms in Excel.
In this article, I will be guiding you on how to insert a checkbox in Excel. After that we will also see an example of how check boxes can be useful.
In excel worksheet, go to Developer tab and click on the Insert drop down and select the Checkbox control as shown above.
Now, you can draw a checkbox anywhere on your worksheet.
Next, you can customize the checkbox using the Format Control option. You can right click on the checkbox and select format control.
In the Format Control window you can choose the default checked or default unchecked type of checkbox. In the Cell link, select the cell in your datasheet where you want to show the checked/unchecked status of checkbox. The checked/unchecked status of checkbox is represented by ‘True/False’ respectively.
Example
In this example, I have added 5 check boxes and IF function to find out if the tasks are completed or not.
You can hide column E values if you wish to.
