how to display the drop down menu icon?

  • Thread starter Thread starter Oligo
  • Start date Start date
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.
 
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
Copying a Drop Down Menu 2
Select drop down menu option using libre-calc macro 0
Creating drop downs in a cell contingent on another drop down 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Displaying Drop-Down Menu Options 2
How do I use different colours in drop down menus in Excel 2003? 4
Drop Down Menu 4

Back
Top