Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Sep 8 '11 at 23:03

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 12 down vote accepted
  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.

share|improve this answer
See this link for more information: office.microsoft.com/en-us/excel/HP052022101033.aspx –  Peter Lang Apr 13 '10 at 12:56
Thanks a lot. Best Regards. Jose –  Josemalive Apr 13 '10 at 13:30

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.