Validation List arrow visibility

[Guest]

Hi all,

Is there a way to have the arrows for validation lists be made to be always
visible? The arrow is only visible if a user clicks on the validation cell.

Thanks!

 

[Roger Govier]

Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze

 

[Guest]

Thanks!

--
Robert

Hi

That is the behaviour with Data Validation, the dropdown only appears in the
Active cell.
Debra Dalgleish has information on her site and suggested workarounds.

http://www.contextures.com/xlDataVal08.html#Freeze