How to Select Multiple Options in a Google Sheets Dropdown

Google Sheets dropdowns can hold multiple selections when the rule uses chip format. Edit the dropdown rule, turn on Allow multiple selections, and then choose more than one chip in the cell.

Last verified: July 28, 2026.

This is a built-in Sheets feature, so you no longer need a workaround that joins several checkbox columns or stores comma-separated values by hand.

Turn On Multiple Selections#

1. Open the spreadsheet on a computer.
2. Select the cell or range with the dropdown.
3. Open the dropdown and choose Edit.
4. In the data-validation rules panel, confirm the display style is Chip.
5. Select Allow multiple selections.
6. Click Done.

Click the cell and select each applicable option. The selected values appear as separate chips in the same cell.

If the Option Is Missing#

The dropdown is not using chip format#

Multiple selection works only for chip-format dropdowns. Change the display style from Arrow or Plain text to Chip, then reopen the rule.

You are editing a range-based dropdown#

Check the rule's criteria and display style. If the control still does not show the option, create a small test dropdown directly in a blank cell to isolate the existing rule.

The options contain extra spaces#

Leading or trailing spaces can prevent multiple selections from behaving as expected. Clean the source values before using them in a dropdown rule.

Mobile Limitation#

Google's current dropdown instructions note that you cannot select multiple dropdown options on mobile, even when the rule is enabled. Set up and use multi-select dropdowns on a computer when the workflow depends on choosing several chips.

How Multiple Selections Are Stored#

All selected chips remain in one cell. That is convenient for labels such as teams, milestones, or skills, but it also means formulas that expect one exact value may need to be adjusted.

For reporting, decide whether you want to:

• keep the chips as a human-readable label;
• split the cell into separate values for analysis; or
• use one row per selection in a normalized reporting tab.

Do not mix manual comma-separated text with chip selections in the same column unless your formulas explicitly handle both formats.

Quick Checklist#

• Edit the dropdown rule on a computer.
• Set the display style to Chip.
• Enable Allow multiple selections.
• Remove leading and trailing spaces from option labels.
• Test the rule with two synthetic selections.
• Plan how reports will interpret multiple values in one cell.

Related Google Workspace Fixes#

• Fix “Array Result Was Not Expanded” in Google Sheets
• Why Google Form Responses Are Not Showing in Your Sheet

Get the Add-On#

Get the Add-On - Free

Text To Table Converter

Work faster inside Google Forms, Docs, Sheets, and Slides: Install the free Text To Table Converter add-on for quiz building, choice syncing, QR codes, document tools, and more.

Install free