Google Sheets / 5 min read

How to Create a Drop-Down List in Google Sheets

Set up a Google Sheets drop-down list for statuses, categories, and cleaner data entry without complex setup.

A drop-down list in Google Sheets makes data entry more consistent by limiting cells to approved values such as statuses, teams, categories, or project stages.

Check this first

Decide whether the list should come from typed options or a source range.
Keep option labels short and consistent.
Use a dedicated source tab when the list will grow over time.
Apply the rule to the right range before sharing the sheet.

Working examples

Example status values to use in a drop-down

Open, In progress, Waiting, Done

Why drop-down lists are worth adding

Many formula and reporting issues start with inconsistent labels. A drop-down list prevents variations like Paid, paid, and Payment complete from drifting into the same workbook and breaking summaries later.

That makes drop-down lists one of the highest-leverage setup steps for shared Sheets.

Two good ways to build them

For a short fixed list, typed options are fast. For a list that may expand, use a source range on another sheet so you can update choices without rebuilding validation rules everywhere.

Typed options for small stable lists.
Source ranges for scalable lists.
Color-coded chip style when scanning status columns matters.

Why this supports later formulas

Drop-down lists improve downstream COUNTIF, SUMIF, FILTER, and dashboard formulas because the labels become more reliable. Cleaner inputs usually mean simpler formulas.