data validation - indirect function

[Louise]

Hi all

I have used the data|validation|use list|indirect function so I can choose
various options from a chosen list, however, the drop down arrow only appears
when the cell is selected.

Is there any way you can set Excel so the drop-down arrows are permanently
visible, even when the cell isn't selected?

Thank you
Louise

 

[RagDyeR]

AFAIK, you can't do that, but how about coloring the cell(s) to make them
stand out.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Hi all

I have used the data|validation|use list|indirect function so I can choose
various options from a chosen list, however, the drop down arrow only
appears
when the cell is selected.

Is there any way you can set Excel so the drop-down arrows are permanently
visible, even when the cell isn't selected?

Thank you
Louise