How to create multiple drop-down lists in a cell or cells of an Excel Worksheet

Dependent Drop-down list - A Dependent drop-down list in Excel is a menu whose options depend on the selection made on another Drop-down list.
This video explains how to create a Dependent drop-down list in a cell or cells of an Excel Worksheet.
🍏Playlist for Shorts on Excel
• Short videos on Excel ...
🍓Download my free eBook on Excel Macros
eepurl.com/gpT0RD
🍇Check these Books on Excel
xlncad.com/exc...
🍉Read my articles on Excel
xlncad.com/
🍐Join my online course on Excel Tables
www.udemy.com/...
#dropdownlist #exceltips #exceltutorial

[@mohammadj.shamim9342]

This is a very smart way. But two things. First, there are empty cells in the drop down and I think using the dynamic formula "filter" could solve that problem. And second, when you changed the name to cereal, the depended drop down list did not automatically change. I don't know why.
Thanks

[@nadermounir8228]

Very nice and informative Video

[@laisonkc]

Thank you