Dropdownlist > Arrows

New Contributor

Hi Experts,

i make some dropdownlists in excel, but the arrow always hide when i switch to another cell. I will the arrows always visible, that the user see there is something to change. And the aHow is this possible?


Thanks for your help




4 Replies


Excel does not support that, but see Drop-down List Arrow Always Visible for Data Validation for a workaround.

OK Hans, i will try this. Thanks a lot


@Hans Vogelaar 



Like Mr. Hans Vogelaar Excel does not support that, but excel also has workarounds.


Thx, Nikolino