In this Excel tutorial video I cover a simple method to remove blanks from drop down lists.
0:01 Intro to drop down list with blanks
0:45 Filter Function is Foundational
1:24 Scenario 1
2:03 Scenario 2
2:44 Scenario 3
3:51 Solution Remove Blank
5:43 Outro
I Create simple, practical Excel tutorial videos to help you work smarter and learn new skills. Each lesson covers real-world Excel tips, functions, and formulas — designed for beginners and beyond.
I truly enjoy making these Microsoft Excel tutorials, and I hope the lessons are helpful for you!
Subscribe for more tutorials & lessons:
https://www.youtube.com/@JasonLucasExcel?sub_confirmation=1