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

 

hhdfh.PNG

hhdfh.PNGhhsh.PNG

4 Replies

@mariobierotte 

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 

@mariobierotte 

 

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

 

Thx, Nikolino