Drop Down Menus

[wobblywheel]

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

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

Thank

 

[Gord Dibben]

Data Validation>Allow>List

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

 

[wobblywheel]

;1602181']Data Validation>Allow>List

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

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 menu in
a cell. I just want users of a shared sheet to be able mak selectioins
(YES/NO) froma drop down menu.

Thanks-

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


reagards

W