data validation - indirect function

G

Guest

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Error 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
data Validation Dependent List Error 2
dependent lists on data validation 3
Data validation only works once 1
Indirect validation list with blank in list 3
Data Validation Dropdown Error - What am I missing? Seems like an 2
Indirect function and data validation dropdown box 2

Top