Dropdowns and validation
Stop typos at the source with dropdowns, checkboxes and rules for what a cell accepts.
Lessons
In the order the Roadmap teaches them. The free one needs no sign-up.
Free · Confident · 7 min
Make a dropdown list
Give a column a dropdown of fixed choices, pick from it, and stop anything else from being typed.
Start the lessonIn the full course. Confident · 11 min
Dropdown from a range
Build a dropdown whose choices come from a list of cells on another sheet, and stretch it when the list grows.
See the lessonIn the full course. Confident · 10 min
Allow only numbers or dates
Make cells accept only numbers or dates within limits you set, and refuse anything else.
See the lessonIn the full course. Confident · 11 min
Input messages and error alerts
Show people what to type in a cell, and choose what happens when they type something the rule does not allow.
See the lessonIn the full course. Confident · 8 min
Checkboxes
Put checkboxes in a column, tick them with a click, and count how many are ticked or still left.
See the lessonIn the full course. Advanced · 11 min
Dependent dropdowns
Make a dropdown offer only the choices that fit what another cell says.
See the lessonIn the full course. Advanced · 10 min
Prevent duplicate entries
Make a column refuse any entry that is already in it, such as a repeated ticket number.
See the lessonPaths with these lessons
A path is a short list of lessons from the course, picked for one goal.
Get the full course
Every lesson in the Excel course, with new lessons added as they're written.
- All 217 Excel lessons open today, and every new one as it's written.
- The Roadmap, Skills and all eight paths.
- A cheat sheet for every lesson you finish.
- At checkout, add the Google Sheets course for US$49.