Limit an Excel cell to one of two possible values
Microsoft describes this here: Apply data validation to cells
-
Click the cell you want to restrict value for
-
Go to Data -> Validation. The Data Validation dialog box opens
-
In the Allow dropdown select List
-
In the Source text box enter
Yes,NoNote: This will also work for more than two possible options; simply separate additional desired options with a comma.
Now your cell will have a dropdown with Yes and No. The user can also type these values without clicking the dropdown button.
