Apr 28 2021 06:39 AM
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.
Apr 28 2021 06:45 AM
Clear All shall work if you stay on cell(s) with data validation. Perhaps you may provide small sample file?
Apr 28 2021 07:37 AM
Apr 28 2021 07:57 AM