Excel Roadmap
The lesson player with the free lesson Your first pivot table in the practice Excel: a pivot table of revenue by region, the PivotTable Fields pane beside it, and the lesson panel with the step "Drag Revenue into Values" checked.
How a lesson looks on a computer.

Confident · 7 min · 9 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 Excel in your browser, and every step is checked as you go. Free, with no sign-up.

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

The full Excel course: 217 lessons, US$149.

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

See the Excel 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.
Excel Roadmap

Not affiliated with Microsoft or Google.