Inserting yes/no dropdown menu

[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?

 

[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

 

[Gord Dibben]

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

No cells needed.


Gord Dibben Excel MVP

 

[Neil Greenough]

Many thanks Pete - much appreciated.

All sorted now!

 

[Pete]

Thanks, Gord.

I didn't know that!

Pete