drop-down list icon

[Iyue]

Is there a way make the drop-down list icon (from Data-Validation) remain
visible without selecting the cell; in the same manner a combo box can always
be seen?
Thanks,
Iyue

[Debra Dalgleish]

No, only the active cell can have the data validation arrow visible.
Perhaps you could colour the cells to highlight them, or add comments to
the cells to mark them.

Iyue wrote:
> Is there a way make the drop-down list icon (from Data-Validation) remain
> visible without selecting the cell; in the same manner a combo box can always
> be seen?
> Thanks,
> Iyue


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