A dropdown list restricts what can be entered in a cell to a predefined set of options. This keeps your data consistent — no typos, no "Done" vs "done" vs "DONE" mismatches — which matters whenever formulas rely on those values.

---

Method 1: Type the Options Directly

The fastest approach for short, stable lists.

  1. Select the cell or cells where you want the dropdown
  2. Click Data > Data validation
  3. Under Criteria, select Dropdown (from a list)
  4. Type your options separated by commas: Not Started, In Progress, Done, Blocked
  5. Click Save

A small arrow appears in the cell. Click it to see the options.

---

Method 2: Use a Range as the Source

For longer lists or lists that need to be updated frequently, store the options in a range and point the validation to that range. When you update the range, all dropdowns update automatically.

Put your options in a spare column or on a separate tab. For example, on a tab called Lists, put your status options in column A:

| A | |---| | Not Started | | In Progress | | Done | | Blocked | | Cancelled |

Then:

  1. Select the cells where the dropdown should appear
  2. Click Data > Data validation
  3. Under Criteria, select Dropdown (from a range)
  4. In the range field, type: Lists!A1:A5 (adjust to your actual range)
  5. Click Save

Now if you add "On Hold" to the Lists tab, the dropdown updates everywhere it's referenced.

---

Method 3: Dependent Dropdowns

A dependent dropdown changes its options based on what's selected in another dropdown. The classic use case: select a category, and the next dropdown shows only products in that category.

This uses INDIRECT and named ranges. The full setup is covered in How to Create Dependent Dropdowns in Google Sheets.

---

Applying a Dropdown to an Entire Column

To add a dropdown to every cell in a column (not just a fixed range):

  1. Click the column header to select the entire column
  2. Open Data > Data validation
  3. Set your criteria and click Save

Every cell in that column now has the dropdown. New rows automatically get it too.

Alternatively, select a large range like C2:C1000 to cover future rows without applying to the header.

---

Show a Warning vs Reject Invalid Input

Under On invalid data in the validation panel:

  • Show warning — allows any input but flags non-dropdown values with a red triangle. Use this when you want flexibility but visibility.
  • Reject input — prevents saving any value not in the list. Use this for strict data entry.

For most tracking use cases, Reject input is better. It prevents the "why is my SUMIF returning 0" problem caused by typos.

---

Removing a Dropdown

  1. Select the cells with the dropdown
  2. Click Data > Data validation
  3. Click Remove validation

---

Common Problems

The dropdown arrow appears but clicking it shows nothing

Your range-based source is empty or the reference is wrong. Check that the range in the validation panel points to cells that actually contain data.

The dropdown allows values not in the list

You chose "Show warning" instead of "Reject input." Go back to Data validation and change the setting.

Pasting values overwrites the dropdown

Pasting with Ctrl+V can paste both value and format, which may clear validation. Use Ctrl+Shift+V (paste values only) to preserve the dropdown.

---

What to Build on Top of This

Don't want to set this up yourself? Describe your data entry setup and it'll be configured for your sheet. Get it installed