Google Sheets Dropdown Chips: Setup and Use

Google Sheets dropdown chips are colored, pill-shaped choices displayed inside cells; create one with Insert > Dropdown or Data > Data validation, add the choices, and set Display style to Chip. They make allowed entries easy to recognize, but they are a visual style for a dropdown rule—not a separate kind of data or the same thing as a people or file smart chip.

What a dropdown chip does

A dropdown rule gives a cell a defined set of acceptable values. When someone clicks a cell with the rule, Sheets shows the available choices. If the rule uses the Chip display style, the selected value appears as a colored rounded label in the cell. For instance, a project tracker could offer Not started, In progress, and Done, with a distinct color assigned to each status.

The cell still contains the selected label as its value. A chip does not automatically link to another file, person, or record, and its color does not change the underlying text. Formulas, sorting, and filters work with the value, not with the visual shape. This makes dropdown chips useful for consistent data entry and scanning a sheet, rather than a special data type with extra behavior.

Google Sheets also uses the word chip for smart chips, such as chips that represent people, calendar events, or files. Those can show linked information and have different behavior. A dropdown chip is simply a cell value displayed using the Chip style of a data-validation dropdown.

Create a dropdown chip

In Google Sheets in a web browser, select the cell or range where people should make a choice. Use Insert > Dropdown to add a rule directly, or use Data > Data validation and select Add rule. The options appear in a side panel. The exact wording or arrangement of controls can change as Google updates Sheets, but the rule is configured in that panel.

Under Criteria, choose Dropdown to enter choices yourself, or Dropdown (from a range) to use values already in the sheet.
For a manually entered list, type a label for each option and use Add another item to create more rows. Remove options you do not need.
Use the color control beside an option if you want that choice to have a color. Colors are optional; the labels are the actual values.
Open Advanced options if needed, then set Display style to Chip. The other display styles are Arrow and Plain text.
Choose what should happen when an entry does not match the rule: reject the input or show a warning. Select Done to apply the rule.

Afterward, click a cell in the range and choose an item from its dropdown. You can apply a rule to a single cell, a row or column range, or a nonadjacent selection if you select the intended cells before creating the rule. For a shared sheet, it is usually clearer to apply the rule to the data-entry cells rather than to a whole column that also contains headings or notes.

Choose between a typed list and a range

A manually entered dropdown is convenient when the choices are short and unlikely to change. A task status list, for example, might contain Not started, In progress, Blocked, and Done. Keeping the list in the rule makes it quick to set up and easy to understand when there are only a few options.

Choose Dropdown (from a range) when the options already exist in cells or will need regular maintenance. For example, a list of departments could live on a separate reference sheet, and the dropdown rule could point to those cells. Editing the source list is generally simpler than reopening many separate rules, though you should check that the range covers the options you plan to use. Avoid including unrelated cells or blank rows unless you intend them to be part of the source area.

Think about who will maintain the choices. If a team frequently adds categories, a clearly labeled source list can make ownership and updates easier. If the list is fixed and very small, a typed list avoids the extra work of maintaining a separate range. Either way, use stable, distinct labels: entries such as In progress and In-Progress may look nearly identical but are different text values.

Set colors and display behavior

Color is most useful when it communicates a consistent meaning. A team might use green for Done, yellow for Waiting, and red for Blocked. Apply a color to each relevant option in the dropdown rule, and use the same meaning throughout the workbook. Too many colors, or colors chosen only for decoration, can make the sheet harder to interpret.

The display-style choice controls how the selected value appears in the cell. Chip makes the colored pill prominent. Arrow presents the selection more like a conventional dropdown indicator, while Plain text displays the value without the chip treatment. The dropdown interaction is still based on the validation rule; changing the display style does not turn the cell into a different type of content.

Consider the layout before choosing Chip. Chips can make statuses stand out, but their appearance may use more visual space than plain text, especially in narrow columns or dense tables. Widen the column if labels are difficult to read, and avoid relying on color alone to convey an important distinction. The written label remains essential for readers who cannot distinguish the colors or who view the sheet in a different display environment.

Control invalid entries and multiple selections

Data validation can help keep a shared sheet consistent. With Reject input selected, Sheets prevents an entry that does not meet the rule. With Show a warning, a person can enter a value outside the list but receives a warning. Reject input is appropriate when downstream reporting depends on a fixed set of labels; a warning can be more suitable when exceptions are legitimate and should be recorded.

Some Google Sheets dropdown rules offer an Allow multiple selections setting. When available and enabled, a person can select more than one option in a cell. Multiple selection is tied to the Chip display style, so it is not a good fit if the sheet needs a single plain-text choice. The interface and feature availability can vary as Google rolls out changes; check the rule panel for the setting rather than assuming every dropdown supports it. Google’s Sheets mobile apps may not offer the same multiple-selection interaction as the desktop browser.

Use multiple selections only when the data model genuinely allows several answers. A cell containing several selected labels may be less convenient to analyze than one row per answer. If you need to count each selection, filter on individual values, or build a pivot table, test the way your chosen workflow handles the cell contents before using the feature across a large dataset.

Edit, copy, and remove dropdown rules

To revise a rule, select a cell that uses it and open Data > Data validation. The panel shows the rule or rules that apply to the selection; edit the options, source range, invalid-entry behavior, or display style, then save the change. If several cells use the same rule, selecting the relevant range first can make it easier to see whether the change applies where you expect.

Copying a validated cell can copy its rule as well as its value, depending on how you paste. If a pasted cell unexpectedly gains a dropdown, inspect its validation rule. Conversely, copying only a value or pasting without formatting may not carry the rule in the same way as a regular paste. When building a template, test a copy-and-paste workflow on a few cells before filling a large range.

To remove a dropdown, select the affected cell or range, open Data > Data validation, and remove the applicable rule in the side panel. Removing the rule is different from clearing the selected value: a cell can be empty and still retain its dropdown. If you only want to reset a choice, clear the cell’s contents without deleting the rule; if you want ordinary cells, remove the rule itself.

Common problems and useful checks

The cell shows an arrow, not a chip: Open the rule and check that Display style is set to Chip. A different display style can use the same list of choices.
A choice is rejected: Check for spelling, extra spaces, or punctuation differences. If exceptions should be allowed, change Reject input to Show a warning.
New source-list items do not appear: Review the range used by Dropdown (from a range). The new items may fall outside the referenced cells.
Colors do not match expectations: Check the color assigned to each option in the rule. The color belongs to that option’s display, not to a general meaning automatically inferred by Sheets.
A cell has a dropdown you did not intend: It may have received a rule through copying or because the selected range included it. Inspect and remove the rule from the unintended cells.
The list is hard to use on a phone: Open the sheet in a desktop browser to access the full rule-editing controls. Mobile interfaces can differ, particularly for newer dropdown features.

For a larger sheet, it also helps to test a few representative cases: a normal selection, an invalid typed value, an empty cell, and a newly added source option. That simple check can reveal whether the rule range, warning behavior, and presentation suit the people who will use the sheet.

Dropdown chips compared with alternatives

Dropdown chips are a strong choice when people should select from a short, controlled list and readers benefit from visible status labels. Plain text is often better when the sheet is intended for dense data entry, when labels are long, or when the chip colors add no useful information. The Arrow style can preserve a visible selection control without giving every value a prominent pill appearance.

Checkboxes suit a yes-or-no choice, such as whether a task is approved, but they cannot represent several named statuses in one simple control. A filter or slicer helps people explore existing data; it does not prevent inconsistent values from being entered. Smart chips are useful when a cell should refer to a person, file, or other supported entity rather than hold one of a set of labels. Choose based on the data you need, not just the appearance.

Excel has its own data-validation dropdown lists, but Google Sheets’ Chip, Arrow, and Plain text display-style controls are Google Sheets features. Do not assume a workbook will look or behave identically when opened in Excel. If a file will move between the two applications, check the dropdowns and their formatting in the destination program.

Frequently Asked Questions

Are Google Sheets dropdown chips the same as smart chips?
No. A dropdown chip is a validated cell choice shown with the Chip display style. A smart chip can represent linked information, such as a person or file, and has different functionality.

Can I make a dropdown chip without adding colors?
Yes. Set the display style to Chip and leave the option colors at their default or neutral appearance. The labels and dropdown rule work independently of whether you assign custom colors.

Can dropdown chips use values from another sheet?
Yes. Select Dropdown (from a range) and set the source to the cells containing your choices. Keep the source range accurate and check it when you add more options. Sheets may require a valid range reference, so confirm the rule accepts the range you enter.

Why can I type a value that is not in the dropdown?
The rule may be set to Show a warning rather than Reject input, or the cell may not have the rule you expect. Check Data > Data validation for that cell and review the invalid-data setting.

Can one cell contain more than one dropdown choice?
Some Sheets dropdowns provide an Allow multiple selections option. It is associated with Chip style and may not be available in every interface or mobile workflow. If you need data that is easy to count and analyze, consider recording each choice in a separate row instead.

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.