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.

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

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.