Delete Option Buttons (Form Controls) in Excel – 3 Methods

Option Buttons (also known as radio buttons) in Excel are part of Form Controls and are commonly used in surveys, forms, and structured data input sheets. They allow users to select a single option from a group, making them useful for interactive worksheets.

However, when a worksheet contains many option buttons, deleting them can quickly become tedious and time-consuming. Excel does not provide a straightforward way to remove only option buttons in bulk, which can make cleanup tasks inefficient. In this article, we will introduce three practical methods to delete option buttons in Excel: using built-in features, VBA, and a much easier solution with Kutools for Excel.

• Delete option buttons using Excel built-in features
• Delete option buttons using VBA
• Delete option buttons instantly with Kutools for Excel

Delete option buttons using Excel built-in features

Excel provides some basic tools to delete objects, including option buttons. These methods work well when you have only a few controls or when precision is not critical. However, they have certain limitations when dealing with large numbers of option buttons.

If your worksheet contains multiple option buttons, you can use Excel’s object selection tool to delete them in batches.

Steps:

1. Go to the Home tab.
2. Click Find & Select > Select Objects.

   

3. Click and drag the mouse across the range to select the option buttons.

   

4. Press the Delete key.

Result

All selected option buttons are deleted immediately.

Because of these limitations, Excel’s built-in method is not ideal when you need to delete only option buttons within a specific range.

Delete option buttons using VBA

If you need more control and want to delete only option buttons within a selected range, VBA provides a more flexible solution. This method is especially useful for advanced users or repetitive tasks.

How to use this VBA code

1. Press Alt + F11 to open the VBA editor.
2. Click Insert > Module.
3. Paste the following code into the module window.

   

   VBA code to delete option buttons in a selection

   Sub DeleteOptionButtonsInSelection()
       'Updated by Extendoffice 20260325
       Dim rng As Range
       Set rng = Application.InputBox("Select a range:", "Kutools for Excel", Selection.Address, Type:=8)
       If rng Is Nothing Then Exit Sub  
       Dim shp As Shape
       For Each shp In ActiveSheet.Shapes
           If shp.Type = msoFormControl Then
               If shp.FormControlType = xlOptionButton Then
                   If Not Intersect(shp.TopLeftCell, rng) Is Nothing Then
                       shp.Delete
                   End If
               End If
           End If
       Next shp
   End Sub

4. Press F5 to run the code.
5. In the pop-up dialog, select the range where you want to delete option buttons. Click OK.

   

Result

Excel will delete all option buttons (Form Controls) within the selected range.

Delete option buttons instantly with Kutools for Excel

If you are looking for a faster and easier way to remove option buttons without writing code, Kutools for Excel provides a dedicated feature that allows you to delete only option buttons in a selected range without affecting other objects, all in just one click.

Steps:

1. Select the range where you want to delete option buttons.
2. Select Kutools > Delete > Batch Delete Option Buttons.

   

Results

All option buttons (Form Controls) within the selected range will be deleted immediately.

Why use Kutools for Excel

• Deletes only option buttons (no risk of deleting other objects).
• Works within a selected range (precise control).
• No VBA or technical knowledge required.
• Fast and efficient for large worksheets.

This method is especially useful when working with complex forms or survey data that contain many controls.

Conclusion

Deleting option buttons in Excel can range from simple to complex depending on the number of controls and your requirements.

• The built-in methods are suitable for small tasks but lack precision.
• The VBA method provides flexibility but requires technical skills.
• Kutools for Excel offers the fastest and most user-friendly solution, allowing you to delete option buttons in bulk with just one click.

If you frequently work with form controls in Excel, using Kutools can significantly improve your efficiency and simplify your workflow.