Pro lesson · 4 exercises · first one free
Keeping entries clean: drop-down lists and data validation
Create drop-down lists, pick the right validation rule and open a list from the keyboard.
How the lesson works
4 short exercises in a live spreadsheet: answer questions that make you predict results or spot bugs and press the right keyboard shortcuts. Every answer is checked instantly, with hints when you're stuck.
The lesson starts with
Data validation limits what can be typed into a cell. A List rule turns the cell into a drop-down menu, so everyone picks from the same options and spelling stays consistent.Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 4, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.