How to Create a Drop-Down List in Google Sheets (2026)
A drop-down list keeps data consistent by letting people pick from preset options instead of typing free text — great for status columns, categories, and assignees. Google Sheets builds them through data validation. Here’s how.
1. Create a Drop-Down From a Typed List
- Select the cell or range where you want the drop-down.
- Go to Insert > Dropdown (or Data > Data validation > Add rule).
- In the panel, choose Dropdown.
- Type each option in its own field, clicking Add another item as needed (e.g., To do, In progress, Done).
- Click Done.
A chip-style drop-down arrow appears in each selected cell.
2. Create a Drop-Down From a Range
If your options already live in cells (or you want them editable in one place):
- Put your options in a column somewhere (e.g.,
H1:H5) — optionally on a separate tab. - Select the target cells, then Insert > Dropdown.
- Choose Dropdown (from a range).
- Enter or select the range, e.g.
H1:H5(or'Lists'!A1:A20). - Click Done.
Now editing the source range updates the drop-down options automatically.
3. Color-Code the Options
- Open the dropdown rule (Data > Data validation, or click the cell and the edit pencil).
- Next to each option, click the color swatch and pick a fill.
- Click Done.
Selected values then display as colored chips — e.g., Done in green, Overdue in red.
4. Choose What Happens on Invalid Input
In the data validation rule, under Advanced options (or If the data is invalid):
- Show a warning — allows the entry but flags it.
- Reject the input — blocks anything not on the list.
Use Reject to strictly enforce the allowed values.
5. Allow Multiple Selections
Google Sheets supports picking several values in one cell:
- Create the dropdown as above.
- In the rule, look for the Multiple selections option (under display/advanced settings) and enable it.
- Users can now check more than one option per cell.
6. Edit or Remove a Drop-Down
- Edit: Select the cell(s), go to Data > Data validation, click the rule, change the options, and click Done.
- Remove: Open the rule and click Remove rule (trash icon). The values already entered stay; only the drop-down control is removed.
7. Troubleshooting
The drop-down arrow doesn’t appear
Confirm a chip/arrow display style is selected in the rule, and that the rule’s range actually covers the cells you’re looking at.
Existing entries show a red corner / warning
Those values aren’t in the current option list (maybe options changed, or there’s a stray space). Update the list or fix the entries.
Options from a range aren’t updating
The dropdown uses a fixed range. If you added items below it, widen the range in the rule, or reference a full column.
Related Google Sheets guides: How to use conditional formatting · How to remove duplicates · How to use VLOOKUP · How to freeze rows · How to create a pivot table
Ready to automate your busywork?
Carly schedules, researches, and briefs you—so you can focus on what matters.
See what people say
"Before Carly, I relied on a Calendly link, but the whole process felt impersonal and not very professional. Carly changed that by handling all the back-and-forth, so I'm no longer stuck in endless email threads trying to line up schedules.
Now Carly reaches out to candidates, shares my real-time availability, lets them pick a slot, then sends a Zoom link and drops it straight into my calendar. She sends reminders to both of us before each call, which has significantly reduced no-shows and last-minute confusion.
On top of scheduling, Carly acts like a full executive assistant, sending me my schedule the night before so I can prepare for each call. It reminds me of the old x.ai assistant, but Carly is noticeably smarter, faster, and better suited to my healthcare recruitment business."
