See:
http://www.contextures.com/xlDataVal08.html#Freeze
--
Gary''s Student - gsnu200734
"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