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