How to make a dropdown list in Google Sheets (4 methods)
Dropdown lists let users pick from predefined options — perfect for status columns, priority tags, categories, and any field where free-text entry causes messy data. This guide covers 4 methods: the basic dropdown, dropdown from a range, dependent dropdowns (advanced), and colored dropdowns (native feature since 2022).
⚡ Quick Answer
Select the cells where you want dropdowns, go to Data → Data validation, click Add rule, choose Dropdown as the criteria type, enter your options as a list or reference a range, and click Done. The cells now show dropdown arrows with your options.
📋 4 methods in this guide
- Basic dropdown with manual list Most common
- Dropdown from a range Dynamic
- Dependent dropdowns Advanced
- Colored dropdowns Visual
Basic dropdown with a manual list
The simplest and most common method. Use this when your dropdown options are short and unlikely to change often — status values ("Active", "Inactive", "Pending"), priority tags ("Low", "Medium", "High"), or yes/no fields.
Select the cells
Click on the cell (or highlight the range) where you want dropdowns to appear. You can select one cell, an entire column (click column header), or any rectangular range.
Open Data Validation
Navigate the menu:
A side panel opens on the right showing validation rules for this range.
Add a new rule
Click + Add rule. A new rule panel appears with dropdown criteria options.
Choose "Dropdown" as criteria
In the criteria dropdown, select Dropdown. Two option input fields appear (Sheets lets you add more with the "Add another item" button).
Enter your options
Type each option in its own input field. For example: "Active" in field 1, "Inactive" in field 2, "Pending" in field 3. Click Add another item to add more choices.
Save the rule
Click Done. The selected cells now display a dropdown arrow. Click the arrow to see your options and pick one.
By default, if someone types text that isn't in your dropdown list, Sheets shows a warning but allows the entry. To force strict validation, expand Advanced options in the validation panel, then set If the data is invalid: Reject the input. Now typing anything not in the list is blocked entirely.
Dropdown from a range
Use this when your dropdown options live somewhere else in the workbook — a list on another sheet, an existing column of data, or a range that will grow over time. When you update the source range, all dropdowns update automatically.
Set up your source list
On any sheet (often a dedicated "Lists" sheet), type your dropdown options in a column. For example, create a sheet called Lists with regions in column A: North, South, East, West, Central.
Select your target cells
Go to the sheet where you want dropdowns and select the target range.
Open Data Validation and add a rule
Data → Data validation → + Add rule.
Choose "Dropdown (from a range)"
In the criteria dropdown, select Dropdown (from a range). An input field appears for the range reference.
Reference your source range
Type the range including sheet name: =Lists!A2:A10. If you set the range on the same sheet, you can omit the sheet name: =A2:A10. Click Done.
Dropdowns now populate from your source range. Add a new region to Lists!A2:A10 and every dropdown gains that option automatically — no re-editing validation rules needed.
Instead of =Lists!A2:A10 (limited to 9 rows), reference the whole column: =Lists!A2:A. Now your list can grow indefinitely and all dropdowns pick up new options automatically. Blank cells in the range are ignored — they won't create empty dropdown options.
Dependent dropdowns (advanced)
Dependent dropdowns are the classic "category → subcategory" pattern. Pick "Fruits" in the first dropdown and the second dropdown shows only fruit options. Pick "Vegetables" and it shows vegetable options. Requires INDIRECT and named ranges.
Create category lists on a Lists sheet
Set up column headers matching your categories. Column A: "Fruits" header with Apple, Banana, Orange below. Column B: "Vegetables" header with Carrot, Potato, Tomato below. Etc.
Create named ranges for each category
Menu path:
Create a named range called Fruits referencing Lists!A2:A10 (the fruit items, not the header). Create another called Vegetables referencing Lists!B2:B10. Names must exactly match the category values in your first dropdown.
Create the first dropdown
In cell A2 (for example), create a normal dropdown with category options: "Fruits", "Vegetables", etc. Use Method 1 or 2 above.
Create the dependent dropdown
Select cell B2. Open Data Validation → Add rule → Dropdown (from a range). In the range field, enter:
INDIRECT evaluates the text in A2 as a range reference. If A2 contains "Fruits", INDIRECT returns the Fruits named range. Click Done.
Test the cascade
Pick "Fruits" in A2 → B2's dropdown shows only fruits. Change A2 to "Vegetables" → B2's dropdown updates to vegetables. Copy the formula down to apply to more rows.
If your first dropdown has "Fresh Fruits" (with a space) but your named range is "Fresh_Fruits" (with underscore, since named ranges can't have spaces), INDIRECT will fail. Match casing exactly too — "fruits" won't find named range "Fruits". Use single-word category names to avoid these issues.
Colored dropdowns
Since 2022, Google Sheets supports assigning a background color to each dropdown option. Perfect for status columns where "Complete" should be green, "In Progress" yellow, and "Blocked" red. Native feature — no conditional formatting needed.
Set up a basic dropdown first
Use Method 1 to create your dropdown with options. Save the rule with Done.
Reopen the validation rule
Click any cell with the dropdown, then Data → Data validation. Click your existing rule in the panel.
Assign colors to each option
Next to each option in the list, click the small color circle. Pick a background color from the palette. Repeat for each option that needs a color.
Choose "Chip" or "Arrow" display style
Under Display style, pick Chip for a pill-shaped colored badge (cleanest look) or Arrow for a traditional dropdown arrow with colored cell background. Click Done.
Your dropdown values now display with colored backgrounds automatically. This is the fastest way to build visual status columns in Google Sheets.
Comparison — which method should you use?
| Use case | Best method |
|---|---|
| Fixed short list (5 or fewer options) | Method 1 — manual list |
| Growing list or options managed elsewhere | Method 2 — from a range |
| Category → subcategory hierarchies | Method 3 — dependent dropdowns |
| Status columns with visual color coding | Method 4 — colored dropdowns |
| Yes/No or True/False checkboxes | Insert → Checkbox (different feature) |
Troubleshooting
Verify the cell actually has validation applied: click the cell and check Data → Data validation. If no rule exists, the arrow won't show. Also check that display style is set to "Arrow" or "Chip" — not "Plain text".
Default validation shows a warning but doesn't block entry. Enable strict validation: Data validation → your rule → Advanced options → If the data is invalid: Reject the input.
INDIRECT is referencing the wrong cell or your named range isn't set up correctly. Verify: the named range name exactly matches the category value in your first dropdown (case-sensitive), and the INDIRECT reference points at the first dropdown's cell (not the current cell).
Frequently asked questions
Can I create a dropdown list in Google Sheets?
Yes. Google Sheets supports dropdown lists through the Data Validation feature. Select your target cells, go to Data menu, click Data validation, choose "Dropdown" as the criteria type, and enter your options. The cells will then display a dropdown arrow letting users pick from your predefined values.
How do I make a dependent dropdown in Google Sheets?
Dependent dropdowns require dynamic references using INDIRECT. Create your first dropdown normally, then for the second dropdown, use "Dropdown from a range" with a formula like =INDIRECT(A2) that references a named range matching the first dropdown's value. When users select "Fruits" in the first dropdown, the second dropdown shows only fruit options.
How do I add colors to dropdown items in Google Sheets?
In the Data Validation panel, click "Advanced options" and use the color picker next to each option in the dropdown list. Each choice can have its own background color, making status columns and priority tags visually distinct. This is native functionality — no add-ons needed.
Can dropdown lists in Google Sheets pull from another sheet?
Yes. Use "Dropdown from a range" as the criteria type, then enter the range reference including sheet name, like Lists!A2:A10. This lets you maintain your dropdown options on a separate sheet (or even hidden sheet) while the dropdowns appear where users need them.
How do I remove a dropdown in Google Sheets?
Select the cells with dropdowns, go to Data menu, click Data validation, then click "Remove validation" at the bottom of the rules panel. The dropdown arrows disappear immediately. The cells keep any values already entered.