Dynamic Excel Dropdowns – PLUS how to get SEARCHABLE dropdowns!

Excel data validation drop-down lists are ideal for ensuring that data is entered consistently and easy to use. In this video I demonstrate different ways to configure drop-down lists so that they update dynamically as new data is added to the source list. PLUS how to get searchable drop-down lists without upgrading Excel!

Download the Excel file here: https://www.myonlinetraininghub.com/excel-drop-down-lists

Check out my full courses: https://www.myonlinetraininghub.com/

Connect with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/

0:00 Excel drop-down lists, also known as data validation lists
0:28 Creating drop-down lists
3:00 p.m. Dynamic updating of lists on the same sheet
4:15 Dynamically updating lists on different sheets
6:41 Dynamic array as list source
8:21 Searchable drop-down lists

Please take the opportunity to connect and share this video with your friends and family if you find it useful.