Dropdownlist > Arrows

[mariobierotte]

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

[#2]

@mariobierotte 

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

[#3]

OK Hans, i will try this. Thanks a lot

@Hans Vogelaar 

[#4]

@mariobierotte 

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

1. Sugestion with Wingdings 3 from Link from Mr. Vogelaar

...here my suggested solution ..... draw one :)).

Look in the inserted file there you will find both examples. 

Thank you for your time and attention.

Nikolino

[#5]

;) Thx, Nikolino