Make 2 AND 3 levels of dependent data validation lists in multiple rows. It's super easy to set up with named ranges.
🕒 TIMESTAMPS
0:00 What are dependent drop-down lists?
0:40 Prepare data (named ranges)
1:15 Insert level 1 drop-down lists
1:47 Insert level 2 drop-down lists
3:34 Dependent drop-down lists in 3 levels
4:03 Level 1 drop-down lists (for 3 levels)
4:17 Prepare data for 3 levels
5:18 Level 2 drop-down lists (for 3 levels)
5:52 Level 3 drop-down lists
👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: [ Ссылка ]
Learn Power BI for free and create impactful reports in just 30 minutes: [ Ссылка ]
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: [ Ссылка ]
VBA Masterclass. Become a VBA pro in 20 hours: [ Ссылка ]
Power BI Essentials. Master Power BI in 12 hours: [ Ссылка ]
🧑💻HIRE ME AND MY TEAM
We develop custom Excel systems: [ Ссылка ]
Create multiple dependent drop-down lists in Excel [EASY]
Теги
advanced excel tricksexcel online courseexcel tips and tricksexcel for analystsmicrosoft excel tutorialsmicrosoft excelexcel 2016excel 2013excel 2019office 365multiple dependent drop down list in exceldependent drop down list in excelexcel data validation listexcel dependent list indirect not workingdata validation drop down every rowdependent drop down every rowdependent drop down 2 levelsdependent drop down 3 levelscascading drop down