Document Editing Problems

How to Delete a Control or Drop-Down List in Excel

Amos Gikunda Oct 10, 2026 869 views

Question details

The user is unable to move or delete an existing form control or drop-down list on their Excel worksheet and needs instructions on how to remove it.

How to Delete a Control or Drop-Down List in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to clean up an Excel worksheet by removing unwanted form controls or drop-down list objects.
Observed behavior: The control on the Excel worksheet cannot be selected, moved, or deleted, preventing the user from modifying the document layout.

Before you start

Ensure you are using the desktop version of Excel, as controls and drop-down lists often cannot be selected or deleted when using Excel for the Web.

Solution 1Recommended

Use Design Mode in Desktop Excel to Delete the Control

Activating Design Mode through the Developer tab allows you to select and modify form controls that are otherwise locked in user mode.

Form controls are designed to be interacted with rather than edited during normal use. To delete them, you must enter a specific editing mode. Note that this feature requires the full desktop application.

Open the workbook in Desktop Excel

If you are currently viewing the file in a web browser, click the option to open the workbook in your Excel desktop application.

Enable the Developer tab

If the Developer tab is not visible on your top ribbon, go to File > Options > Customize Ribbon, check the box next to 'Developer' in the right pane, and click OK.

Turn on Design Mode

Navigate to the Developer tab on the ribbon and click 'Design Mode' in the Controls group to activate it.

Select and delete the control

Click on the stubborn control or drop-down list to select it. Once selected, press the Delete key on your keyboard to remove it completely.

Use Design Mode in Desktop Excel to Delete the Control

Check Your Environment: If the control still cannot be selected even with Design Mode enabled, confirm once more that you are not editing the file in Excel for the Web, which lacks full form control management.

Manage Spreadsheets Easily

Delete Form Controls Quickly with WPS Spreadsheet

WPS Office offers a robust, free spreadsheet editor with full support for developer tools and form controls. You can effortlessly manage, edit, and delete drop-down lists in a familiar interface.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the workbook containing the unwanted control.
2. Access Developer Tools: Click on the 'Developer' tab located in the top ribbon menu.
3. Enable Design Mode: Click the 'Design Mode' icon to unlock the ability to select form elements.
4. Delete the control: Click on the drop-down list or control to select it, then press Delete on your keyboard.

Fully compatible with Microsoft Excel (.xlsx and .xls) filesBuilt-in Developer tab with Design Mode for easy control managementFree, lightweight, and fast-loading spreadsheet editorIdentical workflow to standard office software for a seamless transition

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I see the Developer tab in Excel?

The Developer tab is hidden by default to keep the interface clean for general users. You can enable it anytime by right-clicking anywhere on the ribbon, selecting 'Customize the Ribbon', and checking the 'Developer' box in the main tabs list.

How do I remove a standard data validation drop-down list?

If your drop-down list was created using Data Validation rather than a form control, select the cell, go to the Data tab, click 'Data Validation', and then click 'Clear All' in the bottom left corner of the dialog box.

Can I delete form controls in Excel for the Web?

No, Excel for the Web has limited support for interactive form controls and developer tools. You must open the document in a desktop spreadsheet application, such as Excel or WPS Office, to select and delete these elements.

What should I do if the control is part of a grouped object?

If the control is grouped with other shapes or images, you may need to ungroup them first. Right-click the grouped object, select 'Group', and then choose 'Ungroup'. After ungrouping, you can select the specific control and press Delete.

Document & File Issues