Forum Discussion
belindajberkeley
Feb 14, 2025Copper Contributor
Drop down list
I created a drop down list in excel on my mac. It produced an empty box near the text cells in the list. How do I remove this?
NikolinoDE
Feb 14, 2025Platinum Contributor
It sounds like Excel created a floating object (such as a text box or shape) when you made the dropdown list. Here’s how to remove it:
Solution 1: Delete the Floating Object
- Click on the empty box. If it gets selected, it’s likely a shape or text box.
- Press Delete on your keyboard.
- If it doesn’t delete, try right-clicking it and selecting Cut or Delete.
Solution 2: Use Selection Pane to Find and Delete
- Click anywhere in the Excel sheet.
- Press Command (⌘) + Shift + Option + K to open the Selection Pane.
- Look for any unnamed objects in the list that don’t correspond to your dropdown.
- Select them and press Delete.
Solution 3: Check for Data Validation Input Message
- Select the cell with the dropdown.
- Go to Data > Data Validation.
- In the Input Message tab, uncheck "Show input message when cell is selected".
- Click OK.
My answers are voluntary and without guarantee!
Hope this will help you.