A Smarter Way to Create Drop-Downs in Excel @GoodlyChandeep
A Smarter Way to Create Drop-Downs in Excel  @GoodlyChandeep
Uploaded February 2026 | Updated November 2026, 4 days ago
In this video, I show a simple way to create a drop-down list in Excel using an existing column of data. Instead of manually typing values, you’ll use tables, the INDIRECT function, and data validation so the list updates automatically as your data changes.


===== ONLINE COURSES =====
✔️ Grab My Power Query Book -
products.goodly.co.in/power-query-book

✔️ Master 'M' in Power Query -
products.goodly.co.in/learn-m-powerquery/?

✔️ Mastering DAX in Power BI -
products.goodly.co.in/learn-dax-powerbi

✔️ Power Query Course -
products.goodly.co.in/learn-power-query

✔️ Master Excel Step-by-Step-
products.goodly.co.in/learn-excel


===== LINKS 🔗 =====
Blog 📰 - goodly.co.in/blog
Corporate Training 👨‍🏫 - goodly.co.in/training
Need my help on a Project 💻- goodly.co.in/consulting


===== CONTACT 🌐 =====
Twitter - twitter.com/chandeep2786
LinkedIn - linkedin.com/in/chandeepchhabra
Email - goodly.wordpress@gmail.com


===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!
A Smarter Way to Create Drop-Downs in ExcelGet All  Measures in Power BI with This DAX Trick[ ] vs { } in Power QueryStop Using Pivot Tables Like a BeginnerHow to Hide Header Icons in Power BI Reports3 Data Modeling Tips That Make DAX EasierYou’re Probably Making These 4 Modeling MistakesWill AI Take My Job?Create a Pivot Table from Power Query5 Worst DAX Mistakes You’re Probably MakingMassive update on Power BI Totals 😯 #dax #powerbiI fired my Data Analyst
Goodly |

A Smarter Way to Create Drop-Downs in Excel

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER