This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I use lots of data validation drop down list and recently some phantom boxes have been appearing in my spreadsheets. You can select the grey arrow but the list is empty. You then select the cell to get the correct data validation list, which appears to overlay the the box. Can anyone help? I created a new spreadsheet from scratch and it appeared to have fixed it but today i opened the spreadsheet and once again i have phantom drop down lists!!!
I removed all the data validation from the cell and it still remained!
Can anyone help?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
An alternative is to give all your drop down controls custom names instead of the default name 'Drop Down XX'. This will seem like a lot of work at first but it will be more sustainable then having to reply to all the msgbox every time you want to clean up things.
Thanks
Thao Moua (Excel Desktop)
OK, but how can I do that for drop downs created by setting cell validation to "List"? I don't see where I have control over their names. Thanks!
For dropdown control created by cell validation (ie pivottable filter, tables, or any features) you cannot modify the dropdown controls. From your comment above about having 'valid drop-down' I thought you have custom drop down control and did not want the provided temp solution to accidentally delete them.
If you attempt to delete what looks like a dropdown control from a feature that displayed them, Excel will not allow you to delete them. Cell validation is a legacy feature and strangely you can delete the dropdown control. Even if you deleted the cell validation's dropdown control, save the workbook, then open the workbook, the cell validation dropdown will be restored.
Thanks
Thao Moua (Excel Desktop)
Did you mean to say "...and strangely you can't delete..."? If so, then I follow you.
On one sheet (and only one sheet) I was able to push the phantom drop-down to the right far enough so it would land in a hidden column. On another sheet, the phantom drop-down wouldn't move when I inserted cells to the left of the affected cell.
You'll be sending this to the developers to fix, correct? Thanks, Thao!
We are having the same phantom problem. has anyone found a fix yet?