When working in Excel, you might be highly focused on numbers, formulas, and general data, but you can also make simpler things like a To-do list, but how can you make it if you don’t even know how to insert a checkbox? Thus keep reading because here you will find out!
Note: Inserting checkboxes is the first step of a more advanced operation before putting them to work.
First and foremost, you need to go to the developer tab to start this process, but sometimes it can’t appear in the principal panel. That’s why you ought to enable it by the following steps:
There you have it. Now you can see the “Developer” tab on the ribbon.
Now that you have enabled the “Developer” tab, you need to search the Form Controls commands, which are in the third group of tools you can find next to “Add-ins” once there, you must do the following:
Once you have it, you’ll notice you’ve inserted the check box named by default “Check Box 1” in the selected cell. If you want to remove the caption name text, you must right-click on the checkbox, select the “Edit text” option in the context menu and remove it.
Alright! This is how you can insert a single one, but if you need two or more, you have three options by which you can do it:
Note: Don’t click on the cell itself. So, you need to click near the checkbox and then use the arrow keys to highlight the checkbox you need.
After that, you need to rename it as you prefer and set the size and the position. But don’t worry is quite simple:
Now that you know how to insert a checkbox, you should know how to remove them. You must hit the Ctrl key, pick the cell containing the checkbox, and remove it by pressing the Delete key. Is the same process for a single one of a couple of cells.
If you have multiple checkboxes along the whole document, and it is hard to you to find them all, you can use the following method to erase them:
Then all the cells containing checkboxes will be highlighted, and all that remains is pressing the Delete key on your keyboard to remove them.
Try it yourself! Insert all the checkboxes you need and remove them quickly. Remember, you can do more complex operations and use the checkboxes.