showing dropdown selection arrows in spread sheets

R

rongripon

I have figured out how to build dropdowns. now I would like to have the
selection arrows show all the time instead of when you mouse over. Anyone
know how to do that, if it's possible?
 
B

Bob Phillips

You can't with Data Validation. You could either colour the cell as well, or
switch to a combobox.

--
HTH

Bob

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

Jim Rech

You'd have to switch from using the Data, Validation list feature to using a
combo box from the Forms toolbar.

--
Jim
|I have figured out how to build dropdowns. now I would like to have the
| selection arrows show all the time instead of when you mouse over. Anyone
| know how to do that, if it's possible?
| --
| RGGSR
 
Top