Quote:
Originally Posted by Gord Dibben[_2_]
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