How To Add Yes Or No In Google Sheets

Google Sheets is a versatile tool that can be used for various purposes, from managing your data to automating tasks and much more. In this blog post, we will focus on how you can add Yes or No options in Google Sheets, making it easier for you to organize and process data.

Why add Yes/No in Google Sheets?

Adding Yes or No options in Google Sheets can be highly beneficial, especially when collecting survey responses, conducting polls, or handling other similar tasks. It simplifies the decision-making process and makes data analysis much easier.

Process to add Yes/No in Google Sheets

The process is straightforward and doesn’t require any prior coding knowledge. Here’s how you can do it:

Step 1: Select your cell

First off, click on the cell where you want to add the Yes or No option. You can select multiple cells or even an entire column if you want the Yes/No options to be added for each entry.

Step 2: Adding Data validation rule

With your cells selected, go to the “Data” menu at the top of your Google Sheets interface, and click on “Data Validation”.

Step 3: Setting up the rule

In the Data Validation window, under the “Criteria” drop-down menu, select “List of items”. In the box that appears next to it, type “Yes,No” (without the quotes).

Step 4: Save the changes

Simply hit the “Save” button to finalize the changes. Your selected cell(s) should now have a drop-down menu with the options Yes and No.


And there you have it! You’ve just learned how to add Yes or No options in Google Sheets. This simple trick can save you time and make your Sheets more interactive and user-friendly. So go ahead, give it a try and enhance your Google Sheets experience.