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
 
Top