Data ValidationAllowList

In source enter Yes,No

Note: must be comma-delimited with no spaces as I have shown.

Ensure that "in cell dropdown" option is checked.


Gord



On Mon, 28 May 2012 16:38:54 +0000, wobblywheel
wrote:


I am almost a complete novice to Excel and have a couple of quieries. I
will post them separately.

The first is probably a no brainer... HOw do you set drop down menus in
a cell. I just want users of a shared sheet to be able make selectioins
(YES/NO) froma drop down menu.

Thanks

Thanks Gord. I will try that when next at work in a few days time.


reagards

WW