Dropdown Box Icon????

G

Guest

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

Debra Dalgleish

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.
 

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

dropdown list determined by another dropdown list 5
dropdown boxes make file size too large 2
How do I turn off the tiny icons? 3
Excel Dropdown menu 2
Combo Box / Dropdown Box HELP!!!! 3
Data Validation Error 1
in-cell dropdown menus 2
How do I Make a drop-down box longer 2

Top