How to Add Yes/No Drop-Down Lists in Google Sheets

Last Updated on November 3, 2023 by Jake Sheridan

In this tutorial, you will learn how to add Yes/No drop-down lists in Google Sheets.

How to Add Yes/No Drop-Down Lists in Google Sheets

Google Sheets offers a convenient way to add drop-down lists to your cells, which can be helpful if you want to restrict the data that can be entered in a cell.

For example, let’s say you have a cell where you want to enter a “Yes” or “No” response.

You can add a drop-down list to this cell, with the options “Yes” and “No”. This way, you can make sure that only valid data is entered in the cell.

In this guide, we will show you how to add a Yes/No drop-down list in Google Sheets

How to Create a Google Sheets Drop-down List with Yes and No as an Option

Here’s how to create a drop-down list in Google Sheets that only include Yes and No as options.

Step 1

First, select the range of cells where you want to add a drop-down list with a Yes/No option.

In this example, we’ll add data validation to the range B2:B8.

Step 2

Next, select the Data validation option found under the Data menu.

Step 3

In the Data validation dialog pop-up, we can select what criteria to consider when accepting or rejecting input.

Under the Criteria drop-down menu, select the List of items option.

Step 4

The List of items option allows the user to specify what values will show in the cell’s drop-down list.

Each value should be separated by a comma.

We can add a Yes/No drop-down menu by typing “Yes,No” into the provided textbox.

Click on Save to apply the data validation to the selected range.

Step 5

Users should now be able to click on the drop-down arrow to reveal the Yes and No options.

This method makes it easier for users to fill out the form as well as prevent incorrect input such as misspellings.

If the user provides input that is not ‘Yes’ or ‘No’, Google Sheets will show an error indicating that the input is invalid.


This guide should be everything you need to add a Yes/No drop-down list in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.