How To Create A Drop-Down List In Google Sheets (2026)

A drop-down list in a Google Sheets cell lets people pick an answer instead of typing one, which keeps entries consistent.

You can build the list from values you type in or from a range of cells elsewhere in the sheet.

The steps below follow Google’s Docs Editors Help pages for Sheets on a computer, including how to edit, remove and restrict a list.

Quick answer: four ways to add a drop-down

MethodSteps
Insert menuSelect the cell, then Insert > Dropdown
Data menuData > Data validation > Add rule
Right-clickRight-click the cell and choose Dropdown
@ menuType @ in the cell, then choose Dropdowns under the components section

All four open the same Data validation rules panel, where you choose where the list items come from.

Create a drop-down list step by step

  1. Open the spreadsheet and select the cell or cells.
  2. Use any method from the table above to open the Data validation rules panel.
  3. Under Criteria, choose Dropdown from a range, or choose Dropdown.
  4. For Dropdown from a range, select the cells that supply the list.
  5. For Dropdown, type each value and click Add another item for more.
  6. Click Done.

Google’s page says the @ menu also offers presets such as Project status and Priority.

Use a range of cells as the source

Choosing Dropdown from a range keeps the list in cells you can read and edit like any other data.

Google says that when the list comes from a range, changes to that range update the drop-down automatically.

That makes a range the better choice for long lists or lists that change often, because you never reopen the rule to add an item.

Turn existing data into a drop-down

  1. Select the cells that already contain data.
  2. Right-click and choose Dropdown.

If a selected cell already has a drop-down, the other values are added to that existing rule.

Google says the options are ordered by the selected ranges, going down columns first and then across rows.

What happens when someone types something else

By default, an entry that does not match a list item is rejected.

To allow other entries, click Advanced options and set If the data is invalid to Show a warning.

Google’s Learning Center page for data cleanup describes the same choice in older wording, with Show warning or Reject input, an optional Show validation help text box, and a Show dropdown list in cell checkbox.

If your Sheets screen shows those labels instead, use them in the same way.

Change how the drop-down looks

SettingWhere to find it
Display style: Chip, Arrow or Plain textAdvanced options > Display Style
Allow multiple selectionsTick the option in the rules panel; it only works with chip format
Chip suggestions on or offTools > Suggestion controls > Enable dropdown chip suggestions
Chip colour, size and fontFormat the chip; Format > Clear formatting removes it

Google says multiple selections cannot be made on mobile even when the setting is on.

It also says to remove leading or trailing spaces from the options if you want multiple selections to work.

Edit or remove a drop-down

  1. Select the cell or cells.
  2. Click Data > Data validation, or click the drop-down arrow and then the edit button.
  3. Change the items under Criteria, or click Remove Rule to delete the drop-down.
  4. Click Done.

To clear the values in the cells, select them and press Backspace, or choose Edit > Delete > Values.

If a deleted item keeps its colour

Google documents one quirk with coloured items.

If you delete a source value that has an assigned colour, the value and its colour stay under Criteria and cannot be edited.

To remove it, change the source range or change the colour of another item.

Restrict entries without a list

The same Data validation panel can limit a column to a certain kind of entry.

Google’s data cleanup page gives an email check as an example, with Criteria set to Text > contains and the text box set to @.

You then choose Show warning or Reject input and click Save.

Common problems and the cause Google gives

What you seeCause and fix
A typed entry is refusedInvalid entries are rejected by default; set If the data is invalid to Show a warning under Advanced options
Allow multiple selections is unavailableIt can only be turned on for the chip format, so set Display Style to Chip
Multiple selections will not workRemove leading or trailing spaces from the drop-down options
You cannot pick several items on a phoneGoogle says multiple selections cannot be made on mobile
New items in your source range do not appearCheck that the rule uses Dropdown from a range, because only range lists update automatically
A deleted item still shows under CriteriaIt had a colour assigned; change the source range or another item’s colour

Drop-down chips explained

Google’s smart chips page says you can add and customize drop-down chips that display multiple options.

To change what a chip shows, click it and choose an option.

To edit its options, click the drop-down and then its Edit button.

Google says chips can be formatted for colour, size and font style.

The page does not say which plans or platforms support chips, so check your own account if the chip style does not appear.

If you use both programs, here is how to create a drop-down list in Excel.

Once your list is in place, locking cells or protecting a sheet in Google Sheets stops others from changing the rule.

To keep column labels in view while people scroll, see how to freeze rows and columns in Google Sheets.

Sources

Google Docs Editors Help: Create an in-cell drop-down list.

Google Docs Editors Help: Insert smart chips in your Google Sheets.

Google Workspace Learning Center: Tips to format and clean up data.

Leave a Reply

Your email address will not be published. Required fields are marked *