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
| Method | Steps |
|---|---|
| Insert menu | Select the cell, then Insert > Dropdown |
| Data menu | Data > Data validation > Add rule |
| Right-click | Right-click the cell and choose Dropdown |
| @ menu | Type @ 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
- Open the spreadsheet and select the cell or cells.
- Use any method from the table above to open the Data validation rules panel.
- Under Criteria, choose Dropdown from a range, or choose Dropdown.
- For Dropdown from a range, select the cells that supply the list.
- For Dropdown, type each value and click Add another item for more.
- 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
- Select the cells that already contain data.
- 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
| Setting | Where to find it |
|---|---|
| Display style: Chip, Arrow or Plain text | Advanced options > Display Style |
| Allow multiple selections | Tick the option in the rules panel; it only works with chip format |
| Chip suggestions on or off | Tools > Suggestion controls > Enable dropdown chip suggestions |
| Chip colour, size and font | Format 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
- Select the cell or cells.
- Click Data > Data validation, or click the drop-down arrow and then the edit button.
- Change the items under Criteria, or click Remove Rule to delete the drop-down.
- 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 see | Cause and fix |
|---|---|
| A typed entry is refused | Invalid entries are rejected by default; set If the data is invalid to Show a warning under Advanced options |
| Allow multiple selections is unavailable | It can only be turned on for the chip format, so set Display Style to Chip |
| Multiple selections will not work | Remove leading or trailing spaces from the drop-down options |
| You cannot pick several items on a phone | Google says multiple selections cannot be made on mobile |
| New items in your source range do not appear | Check that the rule uses Dropdown from a range, because only range lists update automatically |
| A deleted item still shows under Criteria | It 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.
Related guides
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.