Forum Discussion

Copper Contributor

Apr 28, 2021

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 ...

excel

SergeiBaklan

Diamond Contributor

Apr 28, 2021

Chris_Maloney

Clear All shall work if you stay on cell(s) with data validation. Perhaps you may provide small sample file?

Chris_Maloney
Copper Contributor
Apr 28, 2021
SergeiBaklan ,

I did try that. I've attached a sample file. The cell in question is I-52.
Sample File.xlsx25 KB
- SergeiBaklan
  Diamond Contributor
  Apr 28, 2021
  Chris_Maloney
  
  That's not a data validation, this is Combo Box control
  
  Just select column J and Del
  
  Sample File.xlsx25 KB
  - Chris_Maloney
    Copper Contributor
    Apr 28, 2021
    That worked. Thanks!