Data Validation - Drop-down list - make arrow visible at all times

I have added a Data Validation List to my excel worksheet.
The arrow icon indicating that the cell contains a drop-down list is only
visible when a user selects the cell. I would like the arrow to be visible at
all times. Is this possible?

Thanks.

You can't AFAIK. I colour those cells to highlight them.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"supergoat" <supergoat@discussions.microsoft.com> wrote in message
news:A4263D6F-ED3B-4D59-9314-9CDF03C46706@microsoft.com...
> I have added a Data Validation List to my excel worksheet.
> The arrow icon indicating that the cell contains a drop-down list is only
> visible when a user selects the cell. I would like the arrow to be visible
at
> all times. Is this possible?
>
> Thanks.

No, only the active cell can display a data validation dropdown arrow.

You could use combo boxes, from the forms toolbar, or the control
toolbox, and their arrows would always be visible.

supergoat wrote:
> I have added a Data Validation List to my excel worksheet.
> The arrow icon indicating that the cell contains a drop-down list is only
> visible when a user selects the cell. I would like the arrow to be visible at
> all times. Is this possible?
>
> Thanks.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks for your speedy and helpful responses.