How to Remove Checkboxes from Excel (5 Easy Ways)

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.

To Do list-Remove Checkboxes from Excel

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.

Go To Feature-Remove Checkboxes from Excel

Step 2: Go To Special window pops up. In the Go To Special window, Select Objects then Click OK.

Go To Special window

All the Checkboxes in the worksheet get selected as you can see in the following image.

Selection

Step 3: Press the Delete key, it removes all the Checkboxes from the worksheet.

Go To Feature Final Result-Remove Checkboxes from Excel

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.

Select Objects-Remove Checkboxes from Excel

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.

Selection using mouse draging

Excel then selects all the Checkboxes similar to the picture below.

Select Objects

 

Step 3: Tab the key Delete from Keyboard. It removes all the Checkboxes from the worksheet.

Select Objects Final Result-Remove Checkboxes from Excel

Both Go To Special and Select Objects are similar features. You can use one of them as you desire.


Similar Readings:


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.

Right Click and Delete-Remove Checkboxes from Excel

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.

Right Click and Delete result

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.

Right Click Final Result-Remove Checkboxes from Excel

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.

Keyboard Shortcut-Remove Checkboxes from Excel

Step 2: Tab the Delete Key afterward it removes all the Checkboxes.

Keyboard Shortcut Final Result-Remove Checkboxes from Excel

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.

VBA Macro Code-Remove Checkboxes from Excel

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.

VBA Macro Code Inserting Module

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

Macro Code

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.

VBA Macro Code Final Result-Remove Checkboxes from Excel

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.


Further Readings

Maruf Islam

Maruf Islam

My self, Maruf Islam, an engineer and Excel & VBA Content developer on Exceldemy. I enjoy solving problems, finding workable solutions, and most of the part I really like to take on challenges. On Exceldemy I write articles discussing various way outs of Microsoft Excel's stuck ons.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo