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.
 
Back
Top