how to display a drop down box indicator all the time

G

Gord Dibben

If the dropdown is from Data Validation>List you cannot do this.

Either use a ComboBox instead or add a colored triangle to the cell using
the Drawing Toolbar.


Gord Dibben MS Excel MVP
 
Top