How to Remove Checkboxes from Excel: 6 Methods

Method 1 – Removing Checkboxes from Excel with Go To Command

Steps:

Go to Home >> Select Find & Select (in the Editing section) >> Select Go To Special.

Selecting Go To Special in the Find & Select option

This opens the Go To Special window.

Select Objects >> click OK.

Selecting objects in the Go To Special window

All the checkboxes in the worksheet get selected, as you can see in the following image >> hit the DELETE key.

Press delete key

The final output should appear in the figure shown below.

remove check boxes from excel with Go To Special command

Method 2 – Using Excel Select Objects Option to Remove Multiple Checkboxes

Steps:

Select Find & Select (in the Editing section) >> choose Select Objects from the options.

Choosing Select Objects option in the Find & Select drop-down

Select Objects enables the default selection.

Hold down the left mouse button >> Drag the cursor over the checkbox to select the whole range >> click on the DELETE key.

Selecting check boxes and pressing delete key

That is how simple it is to remove check boxes from Excel.

remove check boxes from excel with Select Objects option

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

Method 3 – Erasing Single Checkbox by Right-Click and Delete Command

Steps:

Right-click to choose a checkbox >> press the DELETE button on your keyboard.

Right click to select check box

The image below shows the final output.

remove check boxes from excel using right click and delete button

Although it’s 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 and then remove them by tapping the DELETE key.

Method 4 – Applying Selection Pane Tool to Eliminate Checkboxes from Excel

Steps:

Jump to the Find & Select drop-down >> click Selection Pane.

Choosing Selection Pane in the Find & Select tool

Left-Click to select all the checkboxes as shown below >> tap DELETE.

Selecting check boxes from the Selection Pane and tapping delete

This removes all the checkboxes at once.

remove check boxes from excel with Selection Pane

Method 5 – Get Rid of Multiple Checkboxes from Excel Manually

Steps:

Right-click each of the checkboxes to select them >> tap on DELETE.

Right click to manually select check box and click delete button

This removes all the checkboxes, as evident in the screenshot below.

remove check boxes from excel manually

Method 6 – Applying Excel VBA Code to Remove Checkboxes

Steps:

Proceed to the Developer tab >> click the Visual Basic button.

Opening Visual Basic editor

Go to the Insert tab >> select Module.

Inserting module

Copy the code from here and paste it into the window below.

Sub Delete_check_box()

For Each objects In ActiveSheet.Shapes

    If objects.Type = msoFormControl Then
    If objects.FormControlType = 1 Then objects.Delete
    End If

Next

End Sub

VBA code for remove check boxes from excel

Code Breakdown

Explain the VBA code used to remove checkboxes.

The sub-routine is given a name, it is Delete_check_boxes().
Use a For Loop to iterate through each shape in the active worksheet and use the If Then statement to delete them.

VBA Code explanation