Office Settings & Configuration

How to Remove an Empty Box Beside an Excel Drop-Down List

Khadija KhanKhadija Khan Nov 10, 2026 868 views

Question details

The user wants to remove an unexplained empty box that appears next to cells containing a drop-down list.

How to Remove an Empty Box Beside an Excel 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 you start

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.

Solution 1Recommended

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.

1
Select the cell

Click on the cell that contains the drop-down list and the appearing empty box.

2
Open Data Validation

Go to the Data tab on the Excel ribbon and click on Data Validation.

3
Disable the input message

Navigate to the Input Message tab in the dialog box, uncheck the box for 'Show input message when cell is selected', and click OK.

Turn off the Data Validation Input Message
Verification: Once disabled, clicking the cell will only display the drop-down arrow without triggering the blank yellow or white box.
Easily Manage Data Validation in WPS Office

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. 1. Select target cell: Open your workbook in WPS Spreadsheet and select the cell where you want the drop-down list.
  2. 2. Open Validation settings: Go to the Data tab and click Validation to open the Data Validation dialog.
  3. 3. Configure the list: Under the Settings tab, choose 'List' from the Allow drop-down and input your items.
  4. 4. Check input message: Switch to the Input Message tab to ensure no accidental blank messages are enabled, then click OK.
Fully compatible with Microsoft Excel (.xlsx and .xls) file formats.Intuitive Data Validation menu for creating clean, error-free drop-down lists.Built-in Selection Pane to easily manage charts, shapes, and floating objects.Free and lightweight alternative for both Mac and Windows users.
microsoft office alternative - wps office

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.