Displaying Drop-Down Menu Options

A

AndyD4

I have created a number of drop-down menu lists. I want to let users of the
spreadsheet know that there is a drop-down option there by displaying the
"drop-down arrow" on the face of Excel, rather than only finding it when they
move to that particular cell. How can I do this?
 
B

Bob Phillips

Just colour the cells and let them know that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

Jim Rech

You've added a drop down using the Data Validation feature. If you want the
drop down to always be visible you should replace that with a combo box from
the Forms toolbar.

--
Jim
|I have created a number of drop-down menu lists. I want to let users of the
| spreadsheet know that there is a drop-down option there by displaying the
| "drop-down arrow" on the face of Excel, rather than only finding it when
they
| move to that particular cell. How can I do this?
 
Top