Drop down list question

  • Thread starter Thread starter Xhawk57
  • Start date Start date
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.
 
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
 
Back
Top