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!
================================================== ===
"Louise" wrote in message
...
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