Drop Down Menus
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
|