Create Dependent Drop Down Lists
Easy steps for Excel dependent drop down list. Conditional data validation based on other cell, like Region and City lists. Videos, written steps, get free Excel file.
What Is a Dependent Drop Down List?
Video: Dependent Drop Down Lists
Get Started: Dependent Drop Down Lists
- Set up 2 sheets in the workbook
- Create lists for the drop downs
- Set up the main drop down list
- Add the dependent drop down lists
- Test the drop downs
Advanced Dependent Drop Downs
- Use Two-Word Items
- Use Illegal Characters
- Add a 3rd Dependent Drop Down
- Use Dynamic Source Lists
- Dependent Drop Down IF Formula
- Show Long or Short List
Prevent Invalid Selections
Download the Sample Files