How to Add Yes No Drop-down in Google Sheets

To add a Yes/No dropdown in Google Sheets, select the cells, choose Insert > Dropdown, replace the two options with Yes and No, choose colors, and click Done.

The dropdown keeps entries consistent for tasks such as approvals, attendance, and checklists.

Create a Yes/No dropdown

This example adds a dropdown to B2:B5 for four attendance responses.

1. Select cells B2:B5.
2. Choose Insert > Dropdown.
3. Replace Option 1 with Yes and Option 2 with No.
4. Choose green for Yes and red for No.
5. Click Done.

Click a cell’s dropdown chip and choose one response. In the verified example, B2 contains Yes and B3 contains No.

You can also open this panel through Data > Data validation. Right-clicking a selected cell and choosing Dropdown is another quick entry point.

Apply the dropdown to a whole column

Select a column range such as B2:B before creating the rule. Starting at B2 leaves B1 available for a heading.

Open the rule later and check Apply to range if you need to expand or reduce its coverage.

Reject entries other than Yes or No

Open the dropdown rule and expand Advanced options. Under If the data is invalid, keep Reject the input selected.

Reject input was the default in the tested rule. When “Maybe” was entered in B4, Google Sheets showed a validation dialog and left B4 blank.

If you choose Show a warning instead, Sheets allows another value but marks it as invalid. Use that setting only when exceptions are useful.

Change the colors and display style

Click the color circle beside each option to choose its color. Green for Yes and red for No make the two states easy to distinguish.

Under Advanced options, choose one of three display styles:

• Chip shows the value inside a colored label.
• Arrow shows the value with a dropdown arrow.
• Plain text shows the selected value without a chip or permanent arrow.

The verified rule used Chip and allowed one selection per cell. That single-select behavior fits a Yes/No question because the responses are mutually exclusive.

Use Yes and No from a source range

A source range is useful when several dropdown rules should use the same editable list.

1. Enter Yes in H1 and No in H2, outside the dropdown destination.
2. Select the destination cells, then choose Data > Data validation.
3. Add a rule and set Criteria to Dropdown (from a range).
4. Set the source to H1:H2, then click Done.

Editing the source list updates the choices that the rule reads from that range. Existing cell values may need review if you remove an option.

The source can also be on another tab, such as List!A1:A2. Keep it outside the destination range so the rule and its choice list do not overlap.

Use a named range for the choices

A named range gives H1:H2 a readable name that you can reuse in dropdown rules.

1. Choose Data > Named ranges.
2. Add a range named GS_YesNoOptions and point it to H1:H2.
3. Select D2:D5 and create a Dropdown (from a range) rule.
4. Enter =GS_YesNoOptions as the source and click Done.

The saved rule used =GS_YesNoOptions as its criterion. Opening D2 showed Yes and No, confirming that the named range supplied both choices.

Edit or remove the dropdown

Select a dropdown cell and choose Data > Data validation. Click the matching rule to change its range, choices, colors, invalid-data behavior, or display style.

To remove the rule, open it and click Remove rule. Removing validation does not automatically clear values already stored in the cells.

Other Google Sheets articles you may also like

• COUNTBLANK function in Google Sheets
• Count cells with text in Google Sheets
• Remove gridlines in Google Sheets