Google Sheets Dropdown Chips: How to Convert Them

To convert an existing Google Sheets dropdown into a chip, select a cell in the dropdown, open Data > Data validation, edit its rule, and under Advanced options set Display style to Chip. This changes how the dropdown value looks, not the choices or the data stored in the cell.

What a dropdown chip is

A dropdown in Google Sheets is a data-validation rule: it gives a cell a list of permitted or suggested values. A chip is one way Sheets can display the selected value. It appears as a rounded, often colored label inside the cell, with a dropdown control for choosing an option. The same rule can instead display an arrow or plain text.

That distinction matters when someone asks to “convert” a dropdown. Usually they mean changing an existing dropdown’s display style to Chip, rather than rebuilding its choices. If a cell merely contains text such as “In progress” but has no dropdown rule, changing the display style alone will not create a dropdown. You must first add a validation rule and define its options.

Chips are useful for status columns, task owners, priority levels, and other short categories. For example, a project tracker might use Not started, In progress, and Done. A chip makes the chosen status visually easy to scan, while the cell still holds a value that can be used for filtering, sorting, and formulas.

Change an existing dropdown to a chip

Select a cell that already has the dropdown. If you want to change a group of cells, select the relevant range, but check which validation rule applies before editing.
Choose Data > Data validation from the Google Sheets menu. The data validation rules panel opens, showing rules that apply to the selection.
Open the rule you want to change. If the panel shows a rule card, click it to edit the rule.
Expand Advanced options, then find Display style.
Select Chip and click Done if that button appears. Check a cell to confirm that the value now displays as a chip.

The wording or placement of controls can shift as Google updates Sheets, but the important setting is the rule’s display style. Do not choose a different criterion or replace the option list unless you intend to change what users can select. If you cannot find a rule for the selected cell, it may be ordinary text rather than a dropdown, or the rule may apply to a different range.

Apply the change to the right cells

A validation rule can cover one cell, a range, or a whole column. When you edit a rule, inspect its applied range in the panel. If the rule covers the entire status column, changing its display style can affect every cell governed by that rule, not just the cell you first clicked. That is often desirable for a consistent tracker, but it can be surprising if the column contains different types of entries.

For a uniform range, select a cell governed by the rule and edit that rule; verify the range shown in the panel before saving. If different parts of the sheet use different rules, edit each rule separately. Selecting multiple cells does not guarantee that they all share one rule, so check the panel rather than assuming a single change will cover every selected cell.

To make a chip style consistent in a new section, copying a cell that already has the intended dropdown may also copy its validation and formatting. Check the copied range afterward: copying can bring over other cell formatting too, and it is not a substitute for checking the rule’s applied range. Avoid deleting a rule just to change its look; deleting it removes the dropdown behavior rather than converting it.

Create a new dropdown that displays as chips

If the cells do not yet have a dropdown, create the rule first. In a browser, select the target cell or range and choose Data > Data validation, then add a rule. Depending on the Sheets interface, Insert > Dropdown is also a direct way to start creating one.

Choose a dropdown criterion. Use Dropdown to enter options directly, or Dropdown (from a range) to draw choices from cells elsewhere in the spreadsheet.
Add the options, such as High, Medium, and Low. If you use a source range, make sure it contains the intended values and that the rule points to the correct cells.
Open Advanced options and set Display style to Chip.
Save the rule, then open the dropdown in a cell and choose a value to confirm that it works.

A directly entered list is convenient when the choices are short and unlikely to change. A range-based list is useful when several dropdowns should draw from one maintained set of values. For instance, you can keep department names on a separate sheet and point multiple validation rules to that list. If the source list changes, check the range used by the rule so that new entries are included.

Choose between chip, arrow, and plain text

Chip, Arrow, and Plain text are display styles for a dropdown rule; they do not represent three different kinds of data. Choose the style that best fits how people use the sheet:

Chip: Best for short categories that benefit from a visible label, such as status or priority. Chips can make a table easier to scan, especially when options have distinct colors.
Arrow: Shows a dropdown arrow while keeping the cell’s value in a more conventional appearance. It can suit sheets where the chip effect feels too prominent.
Plain text: Displays the selected value without the chip treatment or a prominent arrow. It is a restrained choice for dense tables or layouts that prioritize a text-like appearance.

These styles do not change the underlying selected value. If you switch from Chip to Plain text, for example, the cell does not become a different category, and the validation list is not removed. The best choice depends on the sheet’s audience and density: a visually prominent status can help a team, while a large table with many fields may be easier to read with a less decorative style.

Colors, values, and filtering

Dropdown options can have colors, which Sheets uses to give chip choices their appearance. You can set or adjust an option’s color while editing the dropdown rule. Use colors consistently and pair them with clear labels; color alone is a poor way to communicate meaning, particularly for readers who cannot distinguish some colors or who print the sheet in grayscale.

The chip is a visual presentation of the chosen dropdown value, not an image or a separate object. The cell remains part of the grid. You can still sort or filter a table by its values, and formulas that refer to the cell work with the selected text. For example, a COUNTIF condition can match a status value regardless of whether it appears as a chip or plain text. The visible color does not itself become the value used in a formula.

Changing a dropdown’s display style should not replace its choices. However, editing the rule’s criteria, option labels, or source range can affect what users can select. If a spreadsheet relies on exact text matches, avoid casually renaming an option: a formula or lookup expecting the old label may no longer match newly selected values. Existing cell contents and the rule’s permitted choices are related but distinct, so check both when troubleshooting unexpected entries.

Common problems and fixes

The Chip option is missing: Confirm that you are editing a dropdown validation rule, not a cell containing plain text. Open the rule’s advanced options and check the display-style setting. If the selected cells have no rule, add one first.
Only some cells changed: The rule may apply to only part of the range, or other cells may use separate rules. Inspect the applied ranges in the data validation panel and edit the relevant rules.
The dropdown choices changed unexpectedly: Check whether the criterion or its source range was edited. To change appearance only, leave the choices and criterion as they were and change Display style.
A value does not look like a chip: Check that the cell is governed by the edited rule and contains a value from the list. Also confirm that the display style saved as Chip.
Colors do not match expectations: Review the colors assigned to the individual dropdown options. The chip color is tied to the option’s color setting, not to a separate conditional-formatting rule.

If several rules overlap or the sheet has been copied and edited repeatedly, inspect the rules carefully before making broad changes. A small test range can help confirm the intended result without altering a large working sheet. When a change affects shared work, tell collaborators if the new display makes choices more visible or changes the way they interact with the table.

Google Sheets versus Excel

These instructions are for Google Sheets in a web browser. Excel also supports data-validation lists, but its controls and menu paths are different, and Google Sheets’ dropdown chip display style is not a setting you can select by following the Sheets steps in Excel. If you are working in Excel, use Excel’s Data Validation tools and do not expect the same chip-style menu or behavior.

Likewise, a Sheets dropdown is not the same thing as a colored cell created with conditional formatting. Conditional formatting changes appearance based on rules; a dropdown validation rule supplies selectable values and can display its selected value as a chip. You can use both features in a spreadsheet, but changing one does not automatically create or edit the other.

Frequently Asked Questions

Can I turn plain text cells into dropdown chips?
Yes, but first add a dropdown validation rule to those cells and define the permitted choices. Then set its Display style to Chip in Advanced options. Text alone does not contain the dropdown choices or rule.

Will changing a dropdown to a chip change the cell’s value?
No. Changing only the display style changes how the selected value looks. The value remains available as cell content for sorting, filtering, and formulas.

Can I change a whole column to chips at once?
Yes, if the relevant cells use a rule that covers the column or range. Edit the rule and verify its applied range. If the column contains multiple validation rules, edit each applicable rule rather than assuming one change covers all cells.

Can I switch a chip back to a normal dropdown?
Yes. Edit the same validation rule and choose Arrow or Plain text under Display style. This changes presentation; it does not remove the dropdown rule.

Why can I see a dropdown but not a chip?
The rule may be set to Arrow or Plain text, or you may be looking at a cell with no matching dropdown rule. Open Data > Data validation, inspect the rule applied to that cell, and set its display style to Chip if appropriate.

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.