I have a spreadsheet with multiple drop down selection boxes setup using Data
Validation, which all reference different lists.

The problem I have is that one of the dropdown arrows for the validation box
is always visable even when the cell is not selected. For the dropdown to
work properly, the cell must be selected.

I've tried clearing and resetting the Data Validation for this cell, but the
dropdown arrow always remains (even when the validation is completely cleared
off).

Any thoughts on what might be causing this, or how to fix?

Is it really a data validation dropdown, or is it perhap and AutoFilter
dropdown?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CH" wrote:

I have a spreadsheet with multiple drop down selection boxes setup using Data
Validation, which all reference different lists.

The problem I have is that one of the dropdown arrows for the validation box
is always visable even when the cell is not selected. For the dropdown to
work properly, the cell must be selected.

I've tried clearing and resetting the Data Validation for this cell, but the
dropdown arrow always remains (even when the validation is completely cleared
off).

Any thoughts on what might be causing this, or how to fix?