Free demo · Google Sheets · Lesson 8 · Basics · Dropdown lists

Dropdown lists: choose, don't type

Paid, paid and PAID in one column ruin every filter. A dropdown lets people choose from a list, so each value is always written the same way.

Child | Status Asha Kabir Zoya Arjun Diya
  1. 1Select the Status cells › Insert › Dropdown
  2. 2The Data validation rules panel shows your range
  3. 3Type the choices and pick a colour for each
  4. 4Done: click a cell and choose
  5. 5A payment arrives: Pending becomes Paid in two clicks
  6. ✓One spelling only: filters and counts can be trusted
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. Enrol

Tip: press → or Space to step through, ← to go back, R to replay.

About this lesson

A dropdown list lets people choose a value instead of typing it, so a column never ends up with Paid, paid and PAID in three spellings. In Google Sheets you select the cells and choose Insert → Dropdown. The Data validation rules panel opens on the right with the range filled in and Dropdown as the criteria; you type the choices, give each one a colour and click Done. Every cell becomes a coloured dropdown chip: click it and pick. Because each value is always written the same way, sorting, filtering and counting work reliably. Data validation is the general tool behind dropdowns: Data → Data validation lists the rules of a sheet, and under Advanced options you decide whether a wrong entry is rejected or only gets a warning. The full course goes on to dropdowns that take their items from a range, rules for numbers such as an age between 8 and 14, checkboxes, named ranges and protecting sheets and ranges.

Key points

  • Select the cells, then Insert → Dropdown
  • Type the choices and give each one a colour
  • Data → Data validation shows and changes the rules