Google Sheets Dropdown List

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, content calendars, expense trackers, 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:

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 or a college student budget template.

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

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
• Google Docs Editors Help: Insert smart chips in Google Sheets

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.