Limit an Excel cell to one of two possible values
Limit an Excel cell to one of two possible values
Limit an Excel cell to one of two possible values
Re: Limit an Excel cell to one of two possible values
Microsoft describes this here: [Apply data validation to cells ](https://support.office.com/en-us/article/Apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249)
-
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,No`
Note: 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.
[](https://i.sstatic.net/bN6El.jpg)
[](https://i.sstatic.net/u33aw.jpg)
-
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,No`
Note: 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.
[](https://i.sstatic.net/bN6El.jpg)
[](https://i.sstatic.net/u33aw.jpg)