For cells with data validation lists, only the active cell will show the
dropdown arrow. You can colour the cells to guide users.

If you need arrows that are always visible, you can use a combo box from
the Forms toolbar, or from the Control toolbox.

gu4800 wrote:
I have built a little spreadsheet with 3 dropdown boxes for various options.
How do you get it so that those cells have a permanent dropdown "icon"
showing on there - at the moment the dropdown "icon" only appears when you
select that cell. I basically want to direct people to the fact that they
have an option to choose before proceeding. Thanks.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html