Forum Discussion
Chris_Maloney
Apr 28, 2021Copper Contributor
Removing an empty drop down menu
I need help removing an empty drop down menu.
I added some cells to my spreadsheet after placing a drop down menu in a cell. Now the cell where the drop down was still shows an arrow beside it for a drop down, but there are no items listed. I want to get rid of the drop down arrow beside the original cell that now no longer has a drop down.
I did go through the Data tab > Data Validation and clicked on the "Clear All" button. However the arrow still appears beside the cell. How can I get rid of it?
Thanks.
5 Replies
- SergeiBaklanDiamond Contributor
Clear All shall work if you stay on cell(s) with data validation. Perhaps you may provide small sample file?
- Chris_MaloneyCopper Contributor
- SergeiBaklanDiamond Contributor