how to display the drop down menu icon?
 

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.

how to display the drop down menu icon?
 

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

On Wed, 29 Oct 2008 08:42:00 -0700, Oligo wrote:

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.