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

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!
- SergeiBaklan
  Diamond Contributor
  Apr 28, 2021
  Chris_Maloney , you are welcome