Excel - how to display the drop down menu icon?

Asked By yesnoyesno_1 on 29-Oct-08 11:42 AM
hi. i have aready created the drop down menu list using data validation. how
can i display the drop down icon beside the cell instead of it only shown
when the cursor pt to it.




Gord Dibben replied on 29-Oct-08 04:29 PM
DV dropdown arrows cannot be made visible without selecting the cell.

Either use a ComboBox or just color the cell or use drawing toolbar to draw
an arrow in the adjacent cell pointing to the DV dropdown.


Gord Dibben  MS Excel MVP