drop-down list icon

G

Guest

Is there a way make the drop-down list icon (from Data-Validation) remain
visible without selecting the cell; in the same manner a combo box can always
be seen?
Thanks,
Iyue
 
D

Debra Dalgleish

No, only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.
 

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

Appearance of Data Validation Combo Box 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop down list 2
how to display the drop down menu icon? 1
How to delete a drop down box in Excel 2007 1
dependent combo box list, with indirect reference 1
Validation dropdown list is not coming visible 1
Fill Drop Down with List 2

Top