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.

Ali wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html