Google Sheets Roadmap
The lesson player with the free lesson Your first pivot table in the practice Google Sheets: a pivot table of revenue by region, the Pivot table editor beside it, and the lesson panel with the step "Click Add next to Values and choose Revenue" checked.
How a lesson looks on a computer.

Confident · 7 min · 10 steps · checked as you go

Make a dropdown list

Give a column a dropdown of fixed choices, pick from it, and stop anything else from being typed.

Do this lesson on your computer.

It runs beside a practice Google Sheets in your browser, and every step is checked as you go. Free, with no sign-up.

On your computer, go tolearnford.com/go/NA3B

The full Google Sheets course: 215 lessons, US$149.

Lifetime access, a practice Google Sheets in your browser, and new lessons as we add them.

See the Google Sheets course

In this lesson

  • Select the cells first, then Data, then Data validation.
  • Choices can be typed into the rule (Not started,In progress,Done) or come from a range of cells (Lists!B2:B4).
  • Both tools reject other entries by default.
Google Sheets Roadmap

Not affiliated with Microsoft or Google.