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