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

G

Guest

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.
 
B

Bob Phillips

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

--

HTH

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

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drop downs showing down arrow 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
data validation - indirect function 1
Making Drop Down Box Visible with Excel 2003 2
Drop-down list box arrow 2
In-Cell Drop Downs not visible 2
How do i leave the arrow for the drop down list visible in Excel? 2
Usability - drop down box - Arrow INSIDE box? 1

Top