How to Remove an Empty Box Beside an Excel Drop-Down List
Question details
The user wants to remove an unexplained empty box that appears next to cells containing a drop-down list.

- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Creating or interacting with a drop-down list generated via Data Validation.
- Observed behavior
- An empty floating box, shape, text box, or prompt message appears near the cell and persists on the worksheet.
Before attempting to delete the object, click on the cell containing the drop-down list to verify if the empty box only appears when the cell is active. If it disappears when clicking elsewhere, it is a data validation input message rather than a floating shape.
Turn off the Data Validation Input Message
If the empty box appears only when you click the drop-down cell, it is likely an empty input message prompt generated by Data Validation rules.
Click on the cell that contains the drop-down list and the appearing empty box.
Go to the Data tab on the Excel ribbon and click on Data Validation.
Navigate to the Input Message tab in the dialog box, uncheck the box for 'Show input message when cell is selected', and click OK.

Find and Delete Hidden or Floating Objects
If the box is a floating shape or text box that is difficult to click or select normally, you can use the Selection Pane to locate and remove it.
Create Clean Drop-Down Lists with WPS Spreadsheet
WPS Spreadsheet offers a streamlined Data Validation feature that prevents the accidental creation of floating objects, allowing you to build professional and error-free drop-down lists effortlessly.
- 1. Select target cell: Open your workbook in WPS Spreadsheet and select the cell where you want the drop-down list.
- 2. Open Validation settings: Go to the Data tab and click Validation to open the Data Validation dialog.
- 3. Configure the list: Under the Settings tab, choose 'List' from the Allow drop-down and input your items.
- 4. Check input message: Switch to the Input Message tab to ensure no accidental blank messages are enabled, then click OK.

Frequently Asked Questions
Why did Excel create an empty box next to my drop-down list?
This usually happens if you accidentally add a space or leave the title blank in the 'Input Message' tab of the Data Validation settings, causing Excel to display an empty prompt. Alternatively, a floating shape might have been inadvertently drawn during worksheet formatting.
Can I remove all floating objects in my worksheet at once?
Yes, you can press F5 to open the Go To dialog, click Special, select Objects, and click OK. This highlights all shapes, text boxes, and charts in the active sheet, allowing you to press Delete to remove them simultaneously.
What if the Selection Pane doesn't show the empty box?
If the Selection Pane is empty but the box persists, the box is not a shape. It is highly likely to be an Input Message tied to the cell's Data Validation rules, or a cell comment/note. Check the Data Validation settings to clear it.




