allow two possible values in a excel cell

Question

Hi,

I would like to create a cell format for one cell to only allow the value "yes" or "no" for this cell.

How could i do this?

Thanks in advance.

Jose

Answer 1

1. Click cell you want to restrict value for.
2. Go to Data->Validation
3. On the dialog that comes up, for Allow, select List, and for Source, put in "Yes,No".

Now your cell will have a dropdown with Yes and No. User can also type these values without clicking the dropdown button.