Show drop down icon

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
 
D

Debra Dalgleish

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

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

Top