Formatting Issues

How to Remove an Unwanted Drop-Down Object in Excel 365

Rana GarciaRana Garcia Oct 19, 2026 872 views

Question details

The user needs to remove an uneditable drop-down menu that cannot be selected, moved, or deleted using standard methods.

How to Remove an Unwanted Drop-Down Object in Excel 365
Product
Excel 365
Device & OS
not provided
Scenario
Attempting to clean up an Excel worksheet by removing a rogue, floating drop-down list that does not respond to normal cell clicks.
Observed behavior
A drop-down object is visible on the spreadsheet but acts like an unresponsive floating graphic rather than standard cell data validation.
Before you start

Ensure you are on the correct worksheet. Note that selecting and deleting all objects will remove other graphics, such as charts and images, on the active sheet.

Solution 1Recommended

Delete Objects Using the Go To Special Tool

Use this method if the drop-down is a floating worksheet object or form control rather than standard cell data validation.

Often, uneditable drop-downs are actually transparent or stray form controls pasted over cells. The 'Go To Special' menu allows you to isolate and delete these graphical objects without affecting your typed data.

1
Open Go To Special

Navigate to the 'Home' tab on the ribbon, click on 'Find & Select' in the Editing group, and choose 'Go To Special'.

2
Select All Objects

In the dialog box that appears, select the 'Objects' radio button and click 'OK'. This will highlight all floating objects on your active worksheet.

3
Delete the Objects

Press the 'Delete' key on your keyboard to instantly remove the unwanted drop-down objects.

Delete Objects Using the Go To Special Tool
Warning about multiple objects: If you have images or charts you wish to keep, hold the 'Ctrl' key and click them to deselect them before pressing 'Delete'.
Manage Spreadsheet Objects in WPS Office

Easily Remove Unwanted Objects and Drop-Downs in WPS Spreadsheet

WPS Office provides a highly compatible, intuitive Spreadsheet application that makes managing floating objects, data validation, and table formatting simple and stress-free.

  1. 1. Open Your Document: Launch WPS Spreadsheet and open the file containing the unwanted drop-down.
  2. 2. Access the Go To Tool: Navigate to the Home tab, click 'Find and Replace', and choose 'Go To' from the drop-down menu.
  3. 3. Select Objects: Click on 'Objects' to automatically highlight all floating items, including stray drop-down menus.
  4. 4. Delete: Press the Delete key on your keyboard to clean up your worksheet instantly.
Free to download with a familiar, easy-to-navigate ribbon interfaceFully compatible with Microsoft Excel (.xlsx) file formats and featuresAdvanced 'Find and Replace' tools to quickly locate, select, and delete rogue spreadsheet objects
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I click or select the drop-down menu in my Excel sheet?

It is likely a floating form control or shape object rather than standard cell data validation. Because it floats above the cells, normal cell clicks pass right through it. Using the 'Go To Special' > 'Objects' tool allows Excel to target and select these floating graphical items.

Will clearing Data Validation remove my cell colors and borders?

No. Clicking 'Clear All' within the Data Validation menu only removes the drop-down list rules and input restrictions. Your cell formatting, including colors, fonts, and borders, will remain intact.

How do I remove a drop-down arrow if it belongs to an Excel Table?

If the drop-down is an auto-filter arrow generated by an Excel Table, you can remove the table behavior while keeping your data by clicking inside the table, navigating to the 'Table Design' tab on the ribbon, and selecting 'Convert to Range'.