How to Remove Checkboxes from Excel: 6 Methods

Method 1 – Removing Checkboxes from Excel with Go To Command


  • 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


  • 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


  • 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


  • 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


  • 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


  • 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


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

  • Close the VBA window >> click the Macros button >> hit Run.

Executing macro

The results should look like the picture given below.

remove check boxes from excel with VBA code

Download Practice Workbook

Related Articles

<< Go Back to Excel CheckBox | Form Control in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF