Drop down list question

X

Xhawk57

I have created a drop down list on sheet 1 from named lists on sheet 2, does
anyone know how to make the drop down arrows stay visible as opposed to only
showing when the cell is clicked on?

Your help is greatly appreciated.
 
G

Gord Dibben

Not possible using DV list dropdowns.

Color the cell with the dropdown.

Draw a little triangle in the corners of the cell.

Use a ComboBox instead of DV dropdown.


Gord Dibben MS Excel MVP
 

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

Filtered drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop down list 2
Fill Drop Down with List 2
Drop Down List Problem 1
How to Link drop-down list? 2
Data validation list using filtered range 3
To Link drop-down list 1

Top