Drop down list
 

Hi All,

I was just wondering is there a way I can get the drop down list arrow to
stay visible even when the cell is not selected.

Please help

Hi
AFAIK not possible for the validation drop-down

"Jinxy" wrote:

Hi All,

I was just wondering is there a way I can get the drop down list arrow to
stay visible even when the cell is not selected.

Please help

No probs,Cheers anywayz!

"Frank Kabel" wrote:

Hi
AFAIK not possible for the validation drop-down

"Jinxy" wrote:

Hi All,

I was just wondering is there a way I can get the drop down list arrow to
stay visible even when the cell is not selected.

Please help

If you use Data Validation to create a drop down list in a cell, the
arrow is only visible when the cell is active.

If you want arrows that remain visible at all times, you could use a
combo box from the Forms toolbar, or from the Control toolbox.

Jinxy wrote:
I was just wondering is there a way I can get the drop down list arrow to
stay visible even when the cell is not selected.


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