Maruf Islam
Often, we use checkboxes in Excel to demonstrate our To-Do lists’ status and many more. In this article, we discuss how to remove checkboxes from Excel. In order to do that, we use multiple Excel Features, Keyboard Shortcuts as well as VBA Macro Code to remove checkboxes from Excel.
Suppose, in a To-Do list, we show various Tasks with their Importance levels with Status. The Status column contains Checkboxes that offer Checked and Unchecked options for showing Completed and Incomplete respectively.
Dataset for Download
5 Easy Ways to Remove Checkboxes from Excel
Method 1: Using Go to Special Feature
Excel’s Go To Special feature can select multiple types of control elements. In the case of selecting Checkboxes, Go To Special does it with ease.
Step 1: Go to Home > Select Find & Select (in the Editing section) > Select Go To Special.
Step 2: Go To Special window pops up. In the Go To Special window, Select Objects then Click OK.
All the Checkboxes in the worksheet get selected as you can see in the following image.
Step 3: Press the Delete key, it removes all the Checkboxes from the worksheet.
Method 2: Using Select Objects Option
In the Home Tab Editing section, Excel offers another feature to remove Checkboxes as Select Objects. Select Objects option enables the default selection within the worksheet.
Step 1: Hover to Home Tab > Select Find & Select (in the Editing section) > Select Select Objects from the options.
Step 2: Select Objects enables the default selection. Place and Drag the Cursor to select the Checkbox in any cells or in the whole Range.
Excel then selects all the Checkboxes similar to the picture below.
Step 3: Tab the key Delete from Keyboard. It removes all the Checkboxes from the worksheet.
Both Go To Special and Select Objects are similar features. You can use one of them as you desire.
Similar Readings:
- How to Remove Formatting in Excel Without Removing Contents
- Remove Decimals in Excel (13 Easy Ways)
- How to Remove Subtotals in Excel (2 Easy Tricks)
Method 3: Right-Click and Delete Command
One of the first things to remove a Checkbox is to be able to select them. Clicking on them doesn’t do the trick. You have to Right-Click on any Checkbox to Select them. Then you’ll be able to remove the selected ones by simply clicking the Delete key.
Step 1: Move the Cursor above any Checkboxes then Right-Click. Afterward, you can see the checkbox get selected. To negate the Right-Click options menu without deselecting the checkbox, Hit ESC. All this comes down to a result similar to the following image.
At a time using this process, you can Select only one Checkbox.
Step 2: Hit the Delete key from the Keyboard. It removes the selected Checkbox from the worksheet.
Though it’s very tedious work, you can Repeat the process to Select as many Checkboxes as you want. For better representation, we Select all the Checkboxes using this process then remove them by tapping the Delete key.
Method 4: Using Keyboard Shortcuts
As we mentioned earlier, one of the steps to remove a Checkbox is to be able to select it. Pressing CTRL and then clicking on any Checkboxes enable the Checkboxes to get Selected. Afterward, you can simply Delete them by hitting the Delete key on the keyboard.
Step 1: Press CTRL then Click on any or all the Checkboxes. The Checkboxes get Selected as does in the picture below.
Step 2: Tab the Delete Key afterward it removes all the Checkboxes.
Method 5: Using VBA Macro Code
We can write a simple VBA Macro Code to remove all the Checkboxes from a worksheet. Before running the Macro Code, the worksheet looks like the following image.
Step 1: Press ALT+F11 altogether. Microsoft Visual Basic window pops up.
Step 2: From the Toolbar, Select Insert > Choose Module. A Microsoft Visual Basic Module opens up.
Step 3: Paste the following code in the Module.
Sub RemoveCheckboxes()
For Each shp In ActiveSheet.Shapes
If shp.Type = msoFormControl Then
If shp.FormControlType = 1 Then shp.Delete
End If
Next
End Sub
The code declares all the Shapes in the active sheet as msoFormControl then Deletes them.
Step 4: Tab F5 to run the Macro Code. Back to the worksheet, you’ll see the execution of the code removes all the Checkboxes from the worksheet.
Conclusion
In this article, we remove Checkboxes from the Excel worksheet. We use Excel Features like Go To Special and Select Objects, Keyboard Shortcuts as well as VBA Macro Code. Go To Special, Select Objects and VBA Macro Code offer all the Checkboxes to be removed at a time. Other methods remove only a single checkbox at a time. Hope you find your desired methods within our discussed ones. Comment, if you have further quest about the methods or have something to add.
” title=”