A robust tool that offers the user a variety of interactive possibilities is Microsoft Excel. The checkboxes in Excel are one such feature. An interactive tool that lets users select or deselect an option is a checkbox.
Excel’s checkbox feature may seem simple, but it opens up a world of new options for your spreadsheets that will help you stay on top of your objectives, schedule, assignments, and other obligations.
With Excel, checkboxes can be used to make dynamic charts, dashboards, and interactive checklists.
In this post, we will discuss the different tricks and methods to insert checkbox in excel.
How do I add a checkbox to an Excel sheet?
Making a list of the tasks or other items for which checkboxes will be inserted is the first step in creating an Excel checklist.
We’ve made the following grocery list as an example.
The next actions must be taken to insert a checkbox in Excel:
Step 1: Select the Developer tab, then Controls, then Insert. Controls for forms — Box checked.
Step 2: Select the cell where you want to add the first checkbox by clicking there.
Step 3: Drag the checkbox into place. Right-click the check box, choose Edit Text from the context menu, and then delete the text to get rid of the “Check Box 1” label.
The initial checkbox is prepared.
The Checkbox is Copy and paste to Other Cells.
To copy the checkbox cells, drag them to all the cells below.
How can I reach the Excel Ribbon’s Developer Tab?
Turning on the developer tab on the Excel ribbon, which is by default hidden, is the first step towards putting the checkbox. Use these steps to add the developer tab to the Excel ribbon:
Choose Customize the Ribbon by performing a right-click anywhere on the ribbon.
Check the Developer box under Customize the Ribbon, then click OK.
How to link a cell to a checkbox?
As was said before, you must link the check box to a specific cell to record the checkbox status (checked or unchecked). Consider the following steps:
Format Control is selected once you right-click on the checkbox.
Go to the Control tab in the Format Control dialog box, click on the Cell link box, then click on an empty cell on the sheet that you wish to link to the checkbox, or manually input the cell reference:
For more checkboxes, repeat the previous step.
Lastly, check each of the linked checkboxes.
Multiple Checkbox Insertion in Excel
You may add several checkboxes to the same worksheet in a few different methods.
Adding a Checkbox with the Developer Tab Active
Go to the Developer Tab -> Controls -> Insert -> Form Controls -> Checkbox to add several checkboxes.
Now a new checkbox will be added whenever you click anywhere in the spreadsheet.
To enter several checkboxes in Excel, simply repeat the same procedure.
Pasting a Checkbox after Copy
Choose a checkbox that already exists, copy it, then paste it. The keyboard shortcut (Ctrl + D) is another option.
How to delete checkboxes in excel?
By selecting it and clicking the delete key, you may quickly remove a single checkbox from the list. Holding down the Control key while clicking the mouse’s left button will select a checkbox.
If you wish to remove multiple checkboxes:
- Choose all of the items you wish to remove while holding down the Control key.
- Remove the current document.
- Here is a method to acquire a list of all the checkboxes in your worksheet if they are dispersed throughout and you want to eliminate them all at once:
- Choose the Selection Pane by going to Home -> Editing -> Search & Select.
- By doing so, a Selection Pane listing every object on that worksheet will be displayed.
- Hit the delete key after choosing every checkbox you wish to remove (to select more than one checkbox, hold down the control key while selecting).
- Notably, the checkbox names used here are the backend names rather than the caption names.
How to Alter an Excel Checkbox’s Position?
When using shapes and objects in Excel, a common problem is that the shapes and checkboxes are also affected by cell resizing and hiding/deleting of rows and columns.
As you resize or delete cells, do the following to stop the checkbox from moving:
- Choose Format Control by selecting the checkbox with a left click.
- The properties tab should be chosen in the Format Control dialog box.
- Choose Don’t move or size with cells under Object Placement on the properties tab.
- Choose OK.
- The checkbox would now remain in place when cells were resized or deleted.
How to Track the Status of a Checkbox?
You must record the checkbox’s status after adding it to your database. You can determine whether a checkbox is selected or not by looking at its status.
You must connect a selection with a cell to capture the status of the checkbox. When a checkbox is associated with a cell, the cell shows “True” if the checkbox is selected and “False”
Excel ActiveX Checkboxes
We have only discussed the Excel Form Checkbox up to this point, but Microsoft Excel also provides the ActiveX Checkbox, another form of the checkbox.
Also available from the “Developer” Tab > “Insert” option is the ability to put ActiveX checkboxes. Additionally, an ActiveX checkbox and a form checkbox are very comparable in most ways, but there are some significant variations between the two:
There are more layout choices with ActiveX checkboxes. The typeface of the checkbox caption, the backdrop picture, the cursor pointer while it is hovering over the checkbox, and other options are all customizable in ActiveX checkboxes.
Because ActiveX controls are external components and must be launched independently, they occasionally freeze or become inactive.
However, since Form controls are part of Excel, they do not have any of these problems.
Other working systems, like Apple, do not support ActiveX, a Microsoft-based technology.
Additionally, a lot of systems don’t believe ActiveX by default, and unless you add ActiveX controls to the Trust Center, they are disabled.
Another significant distinction between ActiveX and Form controls is that ActiveX controls can be reached directly as objects in the VBA code (faster), whereas Form controls must be located on the current page to be accessed (slower).
Conclusion
That’s all from our side. We have mentioned all the tricks and methods related to how to insert a checkbox in Excel easily, if you know any other method to add the checkbox or have any queries regarding excel do let us know in the comment section below.
FAQ about How to Insert Checkbox in Excel?
How Can I Add a Checkbox to Excel?
On the Developer Tab, choose controls, Insert, Form Controls, and then Checkbox to add a checkbox.
How can I remove a checkbox from Excel?
In the Home Tab of Excel, select Search & Select and then click Choose Objects to remove a checkmark. Now select the checkboxes next to the items you want to remove. To remove checkboxes from the keyboard, press the Delete key.
How do Excel checkboxes function?
Choose Insert, Form Control, and then Checkbox on your Excel sheet after adding the Developer Tab to the Top Ribbon. To adjust the checkbox’s text and size, choose the cell where you wish to insert the checkbox and then right-click on the checkbox.
How can checkboxes be created in Excel?
You must access the Developer Tab —> Controls —> Insert —> Form Controls —> Check Boxes to create a checkbox in Excel. Box checked. To locate the checkbox, drag it to the desired location after clicking on the cell.
How may checkboxes in Excel be aligned?
Click the Align dropdown menu on the Quick Access Toolbar. Choose between the Left, Right, Top, and Bottom Align options.
Also Read: How To Close An App On Mac? (4 Ways)