How to Use Data Validation in Microsoft Excel 2016 Tutorial

In this Microsoft Excel 2016 tutorial, I will explain how you can use Custom Lists to shorten the time when you need to type a list having repetitive names. But Custom Lists has a limit of just repeating the names available in the list in down order alone. In some cases, you might need a Drop Down List of your Custom List from where you may select a particular name. So to accomplish this, we took the help of Defining Names to Cells / Columns and then used those Names in Data Validation to define a Drop Down List with available data from defined Names as a source to the list. ✅ Sample Excel Worksheet Download Link https://goo.gl/vGGRo5 💞 Support For A Cause @ https://www.patreon.com/TheTeacher 🔔 Subscribe for more tutorials: https://www.youtube.com/TheTeacher?sub_confirmation=1 📝 Learn More, Visit: https://www.theteacherpoint.com ✅ Recommend Playlists: 🔹 Microsoft Excel Tutorial Series Playlist http://bit.ly/Excel-2016-Playlist 👌 Follow Me : Twitter - https://www.twitter.com/TheTeacherPoint Facebook - https://www.facebook.com/TheTeacherPoint Instagram - https://www.instagram.com/TheTeacherPoint/ Pinterest - https://in.pinterest.com/TheTeacherPoint/ #ExcelTutorial #MicrosoftExcel #TheTeacher 🌻 A Microsoft Excel Tutorial By The Teacher