Excel Quickie Playlist:    • Excel Quickies  
Excel File: https://www.teachexcel.com/exceltuto...

How to make a drop down menu list using data validation and dynamic arrays in Excel 365.

This is a simple procedure, but very easy to forget.

Additional Resources
Dynamic Arrays (msft): https://support.microsoft.com/enus/o...
Data Validation (msft): https://support.microsoft.com/enus/o...
Full Tutorial (where this came from):    • Ignore Blanks in Data Validation List...  

Excel Courses:
VBA/Macro Course: https://www.teachexcel.com/vbacourse...
Building Professional Forms: https://www.teachexcel.com/premiumco...
Email Course: https://www.teachexcel.com/premiumco...

TeachExcel.com

#msexcel #excelquickie #tutorial