Excel: Show Yes/No field

In Microsoft Excel, you can display a yes/no field in just a few steps. You can use the data validation function for this.

How to display a Yes/No field in Excel

To insert a Yes/No field in Excel, follow these steps:

1. First, select the cells that you want to display with the “Yes” or “No” selection field.
2. Then click on the “Data” tab and under “Data Tools” click on the entry “Data Validation”.
3. In the window that opens, select “List” under “Allow:”.
4. Then enter “Yes;No” in the “Source” field and confirm with “OK”.
5. Now the selected cells have a drop-down menu with the options “Yes” and “No”.

Latest Videos

To display a Yes/No field in Excel, select the desired cells and click “Data Validation” under “Data”.

Then select “List” from the dropdown menu and enter “Yes;No” for the source. Confirm with “OK”.