Do you want to insert a checkbox in Excel? A checkbox is a small square box that can be checked or unchecked depending on the condition. You might have seen this checkbox in many of the forms that you fill online, it is quite interactive as it easily allows you to select and deselect the option.
Let us learn how you can insert a checkbox in the cell of the excel sheet. Along with this, we will also cover:
- Activate Developer Tab
- Insert a Checkbox
- Edit Checkbox
- Insert Multiple Checkbox
- Link a Checkbox to a Cell
Steps to Insert the Checkbox in Excel:
Activate Developer Tab
If you do not have the developer tab then you have to activate it. To activate the developer tab, you have to right-click on the Ribbon and from the displayed menu click on ‘Customize the Ribbon…’ as you can see in the image below.
Insert a Checkbox
Step 1: Suppose I have a list of groceries and I have to add a checkbox in front of each grocery item then just click on the cell where you want to add the checkbox.
Step 2: Now go to the ‘Developer’ tab and in the ‘Controls’ group click on the ‘Insert’ dropdown button.
Step 3: The Insert drop-down menu displays many control buttons from which you have to click on the checkbox you can see in the image below:
Step 4: Now after selecting the checkbox from the Insert button, where ever you will click on the excel sheet it will create a checkbox over there. If it doesn’t lie at its proper place then you can easily drag and drop it to its proper place.
Step 1: Hover your mouse over the checkbox and click on it to select it. Now right click on the checkbox and from the displayed option you have to click on the ‘Edit Text’.
And you can simply add another text instead of ‘Check Box 1’ or simply delete all the text and let the square checkbox all alone.
Insert Multiple Checkbox
To insert the multiple checkboxes at once just simply select the cell with the checkbox and from the right bottom of the cell drag it down or vertically or horizontally to copy the checkbox.
Link a Checkbox to a Cell
Step 1: Click on the checkbox to select it. Now right click on the checkbox and from the displayed options you have to click on ‘Format Control…’.
Step 2: A Format Control window will pop up where you have to go to the Control tab. Now in the Value section, you have to select the value of the checkbox as ‘checked’ and then you have to mention the cell that you want to link to the cell containing the checkbox. Now click OK to confirm the settings.
If you have checked the checkbox then the linked cell will display TRUE value and if the checkbox is unchecked then the linked cell will display FALSE value.
So, this is all about how you can insert, edit, link or duplicate the checkbox in excel.
Leave a Reply