How to Create Drop Down Lists in Excel (Dynamic and Dependent) @SimonSezIT
How to Create Drop Down Lists in Excel (Dynamic and Dependent)  @SimonSezIT
Uploaded November 2026 | Updated November 2026, 3 hours ago
Access the free Prompt Guide for this tutorial ➡️ simonsezit.com/modern-excel-prompts-guide

Take total control over your data entry and eliminate spreadsheet errors with this step-by-step guide to creating dynamic and dependent drop-down lists in Excel. Discover how to set up Data Validation rules alongside customized input messages and error alerts so your sheets stay completely accurate. We'll also cover how to pair GETPIVOTDATA with Data Validation to build interactive, auto-updating reports and dashboards with ease.

🌍 Get unlimited training with Simon Sez IT’s 250+ courses ⏩ simonsezit.com/courses

🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 11,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses

✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT

🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
How to Create Drop Down Lists in Excel (Dynamic and Dependent)How to Fix Bank Errors and Discrepancies in QuickBooks Online with AI AgentsQuickBooks Online (2026): AI Agents and Features for BeginnersHow to Use Copilot in PowerPoint to Create Presentations for Different Audiences | NEW CopilotChatGPT 5.2 Tutorial for Beginners: Introduction to GPT-5 (2026)Excel Copilot Agent Mode: How to Identify Trends, Patterns and Anomalies in SpreadsheetHow to Navigate the Quick Access Toolbar in Microsoft WordHow to Format Charts in ExcelHow to Set Up Payroll in QuickBooks Online (with AI Agent Update)How to Create Data Group Outlines in ExcelHow to Report on a Project in Microsoft ProjectHow to Create Charts and PivotTables With Copilot in Excel
Simon Sez IT |

How to Create Drop Down Lists in Excel (Dynamic and Dependent)

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER