Delete controls on a worksheet

Applies To
Excel for Microsoft 365 Excel 2024 Excel 2021

To work with controls, enable the Developer tab on the ribbon. See Show the Developer tab.

Note

Some Form Controls can be selected and deleted without enabling Design Mode. Design Mode is typically required only for ActiveX controls.

Delete a control directly on a worksheet

If any of the controls are ActiveX controls, ensure that you're in Design Mode.

  1. On the Developer tab, in the Controls group, turn on Design Mode .
  2. Select the control or controls that you want to delete.
    For more information, see Select or deselect controls on a worksheet.
  3. Press Delete.

Delete a control by using the Selection Pane

Use the Selection Pane when a control is hidden behind other objects or is difficult to select.

  1. Select Home > Find & Select > Selection Pane.
  2. In the Selection Pane, select the control you want to remove.
  3. Press Delete.

This method is useful when a worksheet contains many controls, shapes, or charts.