---
title: "Google Sheets Dropdown List — Griddy"
description: "Create a Google Sheets dropdown list with data validation, custom options, colors, ranges, and cleaner status fields for shared spreadsheets."
canonical_url: "https://getgriddy.ai/blog/google-sheets-dropdown-list/"
---

[Blog](https://getgriddy.ai/blog/)/Google Sheets

Google Sheets

# Google Sheets Dropdown List

Create a Google Sheets dropdown list with data validation, custom options, colors, ranges, and cleaner status fields for shared spreadsheets.

Do this with AI

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)

Start in your browser. Also works with Excel and Google Sheets.

[By Justin Freels](https://getgriddy.ai/about/)/Updated August 20, 2026/5 min read

A Google Sheets dropdown list keeps shared spreadsheets clean by limiting a cell to approved options.

Use dropdowns for status, priority, owner, category, approval state, or any field where inconsistent typing would break filters and summaries.

## Create a basic dropdown list

**Step 1.** Select the cells that need the dropdown, such as `D2:D200`.

**Step 2.** Go to Data -\> Data validation.

**Step 3.** Choose Dropdown.

**Step 4.** Add the allowed options, such as `Not started`, `In progress`, `Blocked`, and `Done`.

**Step 5.** Choose colors if the dropdown is used as a status field.

**Step 6.** Click Done.

The selected cells now show a dropdown chip instead of accepting any random text.

This is useful in [project trackers](https://getgriddy.ai/templates/project-tracker/), [content calendars](https://getgriddy.ai/templates/content-calendar/), [expense trackers](https://getgriddy.ai/templates/expense-tracker/), and shared team sheets.

## Create a dropdown from a range

Use a range when the allowed list may change.

Put the valid options in a separate area, such as `H2:H8`. Then select the cells that need validation and choose Data -\> Data validation -\> Dropdown from a range. In the rule panel, select or enter the source range; `H2:H8` is a range reference for the validation rule, not a formula to calculate in a worksheet cell.

Use the source range:

fx

`=H2:H8`

Now the dropdown updates when the source list changes. This is cleaner than editing every validated cell manually.

## Use dropdowns for categories

Dropdowns are especially helpful for categories because category drift breaks reporting.

For example, an expense sheet should not have all of these as separate values:

- Meals
- meals
- Food
- Food and meals
- Dining

Pick one category list and enforce it with validation. That makes filters, pivots, and summary formulas more reliable.

For budget work, this pairs well with a [budget tracker](https://getgriddy.ai/templates/budget-tracker/) or a [college student budget template](https://getgriddy.ai/templates/budget-tracker-for-college-students/).

## Use clear status labels

Good dropdown labels should be short and mutually exclusive.

For a task tracker, use:

- Not started
- In progress
- Blocked
- Done

For an approval workflow, use:

- Draft
- Ready for review
- Approved
- Rejected

Avoid vague labels like "Working", "Checking", and "Almost done" in the same list. They look different but often mean the same thing.

## Common dropdown mistakes

| Mistake | Why it causes problems |
| --- | --- |
| Too many options | Users stop reading and pick the closest match |
| Overlapping statuses | Reports cannot tell what actually needs action |
| No source list | Updating allowed values becomes manual |
| Free text beside dropdowns | The clean field gets bypassed |

## Decide what happens to invalid entries

Dropdowns can reject values that are not on the list or show a warning and allow them, depending on the validation rule’s advanced setting. Rejecting is useful for stable status and category fields. A warning is better when the source data is still being cleaned or when users may need to record a temporary value.

For a list that changes, keep the allowed values in a small setup range and document who owns it. If the source range is moved, shortened, or filled with blank labels, the dropdown can become confusing even though the rule still exists. Test the rule with a valid option, a blank, and an invalid value before copying it across the whole sheet.

Use short, mutually exclusive labels. `Blocked` and `Waiting` should have different definitions, or summaries will count the same operational state in inconsistent ways.

## Sources

- [Google Docs Editors Help: Create an in-cell drop-down list](https://support.google.com/docs/answer/186103?hl=en)
- [Google Docs Editors Help: Insert smart chips in Google Sheets](https://support.google.com/docs/answer/12319513?hl=en)

## The Griddy way

Dropdown setup gets tedious when the sheet has many status, category, owner, and priority fields.

> "Add dropdowns for status, priority, category, and approval state across this Google Sheets tracker"

Griddy can create the validation structure, clean existing inconsistent labels, and make the sheet easier to filter.

Do this with AI

## Turn the instructions into a finished spreadsheet.

Tell Griddy what you need in plain English, then inspect and keep editing the result in the browser, Excel, or Google Sheets.

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)Start in your browser. No download required.

Also works with[Excel](https://appsource.microsoft.com/en-us/product/office/wa200008745)[Google Sheets](https://workspace.google.com/marketplace/app/griddy/206105793696)

[All posts](https://getgriddy.ai/blog/)

Do this with AI

## Ask Griddy to do this for you.

Describe the result in plain English—no formula knowledge required.

[Try Griddy free](https://app.getgriddy.ai/login?mode=register&next=%2F)Start in your browser. No download required.

Also works with[Excel](https://appsource.microsoft.com/en-us/product/office/wa200008745)[Google Sheets](https://workspace.google.com/marketplace/app/griddy/206105793696)

About this guide

Written by Justin Freels, Founder, Griddy.

Updated August 20, 2026/5 min read
