Show drop down icon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I am sure this is a stupid question, but I can't sort it out. I have
various drop-down menus in a worksheet. When you tab across a cell with a
drop-down menu, the drop down icon then appears. When u move off the cell,
the drop down icon does not show. I would like all the cells with a drop
down menu to show the drop down icon permanenetly and not just when the
cursor is in that cell. I know it must be an option somewhere but i have
just started using drop downs, and can't find it. many thanks
 
Only the active cell will show the dropdown arrow, and there's no
setting that will change this behaviour.

You could colour the cells, or add a comment, to indicate that they
contain a data validation list.
 

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

Filtered drop down list 2
how to display the drop down menu icon? 1
Drop Down Calendar in Excel with a Default Value 1
Creating drop downs in a cell contingent on another drop down 1
Multi layered drop down 1
drop downs 2
Data validation only works once 1
Linking choices in drop down menu to have automatic answer... 3

Back
Top