Drop-down lists with data validation
IntermediateAdvanced
7 questions, about 11 minutes
Prevent typos with a drop-down list in a cell.
What we'll do
- Setting up data validation
- Using a list from a range
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
1exampleYou watch
7questionsYou do it yourself