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

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

Great! Many thanks fro the help.

"Gary''s Student" wrote:

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

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