Pick Lists

[Captain Ordinary]

Morning All

I am making a spreadsheet with a number or 'pick lists' (or drop down menus)

Is there any way I can have the 'down arrow' showing before users actually
reach the cell?

And can I somehow lock the cell so they can only choose the options from the
pick list.

Your advice would be gratefully rec'd.

Cheers
CO

 

[Dave Peterson]

Yep.
If you use a Combobox from the Control toolbox toolbar or if you use a Dropdown
from the Forms toolbar.

Nope.
If you use data|validation.

I just shade those data|validation cells a different color when I want them to
stand out.

 

[Paul Lautman]

Morning All

I am making a spreadsheet with a number or 'pick lists' (or drop down
menus)
Is there any way I can have the 'down arrow' showing before users
actually reach the cell?

And can I somehow lock the cell so they can only choose the options
from the pick list.

Your advice would be gratefully rec'd.

Cheers
CO

You could use a combo box, that would be there all the time

 

[Captain Ordinary]

Thanks a lot for your help guys ...
Cheers
CO

You could use a combo box, that would be there all the time