how to display the drop down menu icon?

O

Oligo

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show drop down icon 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Copying a Drop Down Menu 2
drop down menu color 1
Select drop down menu option using libre-calc macro 0
Drop down list 2
drop-down menu disappeared 6
Drop Down List Contains the List Header Row 1

Top