Yes/No Dropdown in Google Sheets: Add One in Minutes

To add a Yes/No dropdown in Google Sheets, select the cell or cells, choose Insert > Dropdown, enter Yes and No as the options, then click Done. You can also create one through Data > Data validation. A dropdown gives people a consistent way to answer, reducing spelling differences and making a sheet easier to filter or summarize.

What You’ll Need

A Google account with access to the spreadsheet, and Google Sheets open in a web browser.
A decision about where the dropdown should appear, such as one cell or a range like B2:B100.
The choices you want to offer. For a basic Yes/No list, the two options are simply Yes and No.

You do not need a formula, add-on, or special template. If other people will use the sheet, make sure you have permission to edit it; viewers cannot add or change dropdown rules.

Step-by-Step

Open the spreadsheet and choose the target cells. Click the cell where the first answer should go. To put the dropdown in several rows, select the full range first, such as B2:B100. You can select a whole column by clicking its letter, but applying the rule only to the rows meant for responses usually keeps header cells and notes unaffected. To select separate cells, hold Ctrl while clicking on Windows or Command on Mac.
Open the dropdown editor. In the top menu, choose Insert > Dropdown. Google Sheets opens a dropdown rule editor, generally in a side panel. If that menu item is not available in your current layout, use Data > Data validation instead, then choose the option to add a rule. Both routes let you define a list of allowed choices.
Check the range the rule will apply to. In the editor, confirm that the cell or range shown is the one you selected. If it is wrong, edit the range field before proceeding. For example, a rule intended for B2:B100 should not accidentally cover B1, where a column heading might be. You can also add or correct the range in the editor if you opened it without selecting cells first.
Set the criteria to a dropdown. Choose the Dropdown criterion, rather than a dropdown populated from a range. The basic dropdown has editable option rows in the rule editor. If the editor shows example choices, replace them with the answers you need. A range-based dropdown is useful when choices are maintained in cells elsewhere, but it is unnecessary for a fixed Yes/No list.
Enter the two choices. In the first option row, type Yes. In the next row, type No. Remove any extra sample options you do not want, or use the control to add another option if you need more choices. Keep the wording consistent: “Yes” and “No” are clearer than variants such as “Y,” “Nope,” or a mix of upper- and lowercase forms.
Choose how Sheets handles other entries. If the editor offers an invalid-data setting, decide whether to reject entries that are not on the list or show a warning. Rejecting input keeps the column limited to Yes and No; a warning allows a person to enter something else after being notified. For a survey or status field that must be consistent, rejecting other values is usually the safer choice. A warning can suit a working sheet where exceptions are legitimate.
Set the appearance and save. If available, choose a display style such as chip, arrow, or plain text. This changes how the selection looks, not what answers are allowed. Click Done to save the rule. Click a cell in the range and use its dropdown control to select Yes or No. Check a second cell in the range too, if you applied the rule to multiple rows.

After saving, the selected answer appears in the cell. The dropdown does not automatically fill unanswered cells, so an empty cell remains empty until someone makes a selection. If you want a heading, such as “Approved?”, put it in a separate header row and apply the rule only to the response cells beneath it.

Common Mistakes

Applying the rule to the wrong range: A dropdown can appear in the header, miss some rows, or affect a different column if the range is incorrect. Verify the range in the rule editor before saving.
Leaving example choices in place: The editor may start with sample options. Replace or remove them so users see only the choices you intend.
Choosing a range-based list by accident: A dropdown sourced from a range depends on the cells in that range. If those cells are blank or contain different text, the menu will not show the two choices you expected. Use the standard Dropdown criterion for a fixed Yes/No list.
Assuming the dropdown fills cells automatically: Adding validation creates a selection control; it does not choose a default answer. Leave cells blank until they are answered, or select a value yourself where appropriate.
Allowing inconsistent alternatives: If invalid entries are only warned about, someone may type “yes,” “Y,” or another variation. Decide whether exceptions are acceptable and choose rejection or warning accordingly.
Overwriting cells without noticing: Pasting content into a validated range can replace its values and may affect the rule, depending on what is copied. Check the affected cells after a large paste or import.

Tips

Apply the dropdown to a planned response range rather than the entire sheet. For example, if row 1 contains headings and responses will occupy rows 2 through 200, select B2:B200. This gives room for future entries while avoiding the heading. If the sheet grows beyond that range, extend the rule to cover the new rows.

Use the same labels everywhere the answer has the same meaning. Consistent values make it easier to filter for Yes or No and to use the column in charts, pivot tables, or later analysis. If a third state is genuinely useful, such as “Not applicable,” add it deliberately and explain what it means rather than asking users to type it in freely.

Choose a display style that suits the sheet. Chips can make status values easy to scan, while plain text may look better in a compact table. Color can provide a visual cue, but do not rely on color alone to communicate meaning; keep the Yes and No text visible.

To reuse a rule, copy a cell that already has the dropdown and paste it into another intended cell or range. After copying, verify the destination and rule because paste actions can bring other cell content or formatting along with validation. For a large or important sheet, editing the rule’s applied range directly is often easier to review.

For collaboration, tell editors what the choices mean and whether the field is required. Google Sheets does not force someone to complete every dropdown cell just because a rule exists. You can use a separate review process to identify blanks. If you need a form-like response experience, consider whether Google Forms connected to a sheet is a better fit.

Troubleshooting

The dropdown arrow or control is missing: Click the cell and check whether the validation rule exists. Open Data > Data validation to review rules and their applied ranges. The cell may be outside the range, or the rule may have been removed. Add the cell to the range or create the rule again.
The menu has the wrong choices: Select a cell with the rule and open its validation settings. Check that the criterion is a standard dropdown and that the option rows say exactly Yes and No. If the rule uses a source range, inspect those source cells or switch to a standard dropdown.
People can type values besides Yes or No: Edit the rule and change the invalid-data behavior from warning to rejection, if that setting is available. A warning notifies users but does not necessarily prevent an alternative entry. Also check whether the cells actually have the rule; a rule on one part of the column does not govern cells outside its range.
A pasted value does not match the list: Pasted data may introduce text that is not one of the allowed choices. Check whether the rule rejects or warns about invalid data, then replace the entry with a dropdown choice. For bulk imports, clean the source values so they match the list before pasting and inspect the destination afterward.
You cannot edit the rule: Confirm that you have editor access, not viewer or commenter access. A protected sheet or protected range may also restrict changes. Ask the owner for permission or for the protected range to be adjusted; do not try to work around a protection you are not authorized to change.
The rule appears to change in other cells too: Multiple cells may share one validation rule. Review its applied range in the side panel. If only certain cells should have the dropdown, adjust the range carefully and check neighboring cells afterward.

Google Sheets updates its interface from time to time, so labels or panel placement may look slightly different. The key items are the selected cell range, the standard Dropdown criterion, the Yes and No option values, and the rule’s invalid-data behavior.

Frequently Asked Questions

Can I add a Yes/No dropdown to an entire column?

Yes. Select the column or a specific range within it, then create the rule. A range such as B2:B100 is often preferable to the whole column because it excludes the header and avoids applying the dropdown to unused cells.

Can I make the cell show Yes by default?

The dropdown rule itself does not set a default answer. Select Yes in the cell if that is the correct starting value, but do not prefill answers when people should make their own choice. A blank validated cell remains available for a later selection.

Can users select both Yes and No in the same cell?

No. A standard dropdown stores one selected option in a cell at a time. If respondents need to choose multiple items, use separate columns or a different input method; do not expect a basic dropdown to work as a multi-select control.

How do I change Yes and No to different labels?

Open the cell’s rule through Data > Data validation, edit the option text, and save. Existing cell values may not automatically become the new labels, so review values already entered and replace any old text as needed.

Does Google Sheets work the same way as Excel?

No. This guide uses Google Sheets in a browser. In Excel for Microsoft 365 on Windows, a comparable list is set up through Data > Data Validation, then Allow: List. The menus and editing controls differ, so follow Excel-specific instructions when working in an Excel workbook.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.