How to Make a Drop-Down List in Google Sheets

Select the cells, then Data → Data validation → Add rule, set the criteria to Dropdown, and type your options. Each cell gets a small arrow to pick from.

To pull the options from a range instead of typing them, choose Dropdown (from a range) and enter something like Sheet2!A2:A20. That way you update the list by editing those cells rather than reopening the rule.

Google has moved this feature between menus more than once, so if your version differs slightly, look for Data validation — the concept is the same wherever it sits. Google's own in-cell dropdown documentation tracks the current interface.

Best for short, stable lists — Yes/No, a handful of statuses.

Select the cells that should have the dropdown. Select the whole column now rather than adding cells later.
Data → Data validation, then Add rule.
Set Criteria to Dropdown.
Type each option as a separate item, using Add another item for each.
Click Done.

Preferable for anything longer than about five options, or any list that will change.

Put your options in a column — often on a separate sheet named something like Lists.
Select the cells that need the dropdown.
Data → Data validation → Add rule.
Set Criteria to Dropdown (from a range).
Enter the range, for example Lists!A2:A50.
Click Done.

Give yourself room. Setting the range to A2:A50 when you have 20 options means new entries in rows 21–50 appear in the dropdown automatically. Blank cells in the range are ignored, so the spare rows cost nothing.

An open-ended range like Lists!A2:A covers the whole column and never needs extending.

Pulling the list from another sheet

Just include the sheet name and an exclamation mark: Lists!A2:A50.

If the sheet name contains a space, wrap it in single quotes: 'Product List'!A2:A50. A missing pair of quotes is the usual reason this fails.

Keeping option lists on a separate sheet is worth the habit — it stops them being sorted, filtered or deleted along with your working data. You can hide that sheet once it is set up; hidden sheets still feed dropdowns.

Warning versus rejecting

Under "If the data is invalid", you choose what happens when someone types something not on the list:

Option	Behaviour
Show a warning	Accepts the entry, marks the cell with a red triangle
Reject the input	Refuses the entry entirely

Reject the input is what most people expect a dropdown to do. The default is more permissive, which is why lists that "should be restricted" often are not — worth checking on any sheet others will fill in.

Colour-coding the options

Dropdown items can carry a colour, which is set within the validation rule itself rather than through conditional formatting. Click the colour swatch beside an item when creating the rule.

This is genuinely useful for status columns — a red "Blocked" against a green "Done" is readable at a glance in a way plain text is not.

Editing and removing

To change the options: if the list came from a range, just edit those cells — the dropdown updates on its own. If you typed the items in, reopen Data → Data validation and edit the rule.
To remove a dropdown: select the cells, open Data → Data validation, and choose Remove rule. Deleting the cell contents does not remove the rule.
To copy one to other cells: copy a cell that has the dropdown and paste normally — validation rules travel with a paste.

When it does not work

No arrow appears. The rule was applied to a different range than you think. Reopen Data validation and check which cells it lists.
The range reference fails. A sheet name containing a space needs single quotes: 'My List'!A2:A20.
Options are missing. The source range is too small, or the missing entries sit below its last row.
Invalid entries still get accepted. The rule is set to "Show a warning" rather than "Reject the input".
Duplicated blank options. Blank cells within the source range — tidy the list, or narrow the range.

What Sheets does not do natively

Two things people frequently ask for, so it is worth being straightforward:

Dependent dropdowns — where choosing "Europe" narrows a second list to European countries — are not a built-in feature. They require either an INDIRECT-based approach with named ranges, or Apps Script.

Behaviour varies by version for multi-select and some newer dropdown options, since Google ships changes to this area regularly. If you need either, check what your current Sheets offers rather than following any tutorial's screenshots.

Dropdowns pair naturally with two other Sheets tasks: highlighting duplicates to catch entries that slipped through, and formulas not updating when a validated cell feeds a calculation.

Frequently asked questions

How do I create a drop-down list in Google Sheets?

Select the cells, choose Data → Data validation → Add rule, set the criteria to Dropdown, type your options, and click Done. Each cell then shows an arrow to pick from.

How do I make a dropdown from another sheet?

Choose "Dropdown (from a range)" and enter the range with the sheet name — Lists!A2:A50. If the sheet name contains a space, wrap it in single quotes: 'Product List'!A2:A50.

How do I add options to an existing dropdown?

If it reads from a range, add the new options to those cells and the dropdown updates automatically. If the items were typed into the rule, reopen Data → Data validation and edit it.

How do I remove a drop-down list?

Select the cells, open Data → Data validation, and choose Remove rule. Clearing the cell contents leaves the rule in place.

Why can people still type anything into the cell?

The rule is set to "Show a warning", which accepts the entry and flags it. Change it to "Reject the input" under "If the data is invalid".

Can I make dependent drop-down lists?

Not as a built-in feature. Dependent dropdowns require named ranges with INDIRECT, or Apps Script. There is no menu option for it.

Do hidden sheets still work as a source?

Yes. Keeping option lists on a hidden sheet is common practice — it protects them from being sorted or deleted with your working data.

Conclusion

Use a range rather than typed items for anything you will maintain, give the range spare rows so additions appear automatically, and set the rule to Reject the input if the point is to restrict what people enter.

Keeping the source list on its own hidden sheet takes an extra minute and prevents the most common way these break — someone sorting or deleting the options along with the data.

Related: highlighting duplicates in Google Sheets covers conditional formatting, and merging cells covers what breaks sorting.