Inserting yes/no dropdown menu

N

Neil Greenough

I want to insert a dropdown menu in a cell so that when the cell is
selected, the user can only choose 'yes' or 'no'? I have done this many
times but how to do it has totally slipped my mind.

Any ideas?
 
P

Pete

Use Data | Validation on the cell and select list - you specify where
the list is stored. You will only need 2 cells, containing Yes and No
 
G

Gord Dibben

Actually Pete, you can just type Yes,No in the source dialog box.

No cells needed.


Gord Dibben Excel MVP
 
Top