How to Remove an Unwanted Drop-Down Object in Excel 365
Question details
The user needs to remove an uneditable drop-down menu that cannot be selected, moved, or deleted using standard methods.

- 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.
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.
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.
Navigate to the 'Home' tab on the ribbon, click on 'Find & Select' in the Editing group, and choose 'Go To Special'.
In the dialog box that appears, select the 'Objects' radio button and click 'OK'. This will highlight all floating objects on your active worksheet.
Press the 'Delete' key on your keyboard to instantly remove the unwanted drop-down objects.

Clear Data Validation Rules
Use this approach if the drop-down is actually anchored to a specific cell or merged cells.
Convert Table to Range or Remove PivotTable
Sometimes uneditable drop-downs are simply filter arrows generated by formatted Excel Tables or PivotTables.
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. Open Your Document: Launch WPS Spreadsheet and open the file containing the unwanted drop-down.
- 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. Select Objects: Click on 'Objects' to automatically highlight all floating items, including stray drop-down menus.
- 4. Delete: Press the Delete key on your keyboard to clean up your worksheet instantly.

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'.




