How to Create Drop Down Lists in Excel Using Named Ranges.
In this quick excel tutorial I’ll show you how to create an excel data validation dropdown list with named range. This is the stepping stone of dependent dropdown list. If you want to learn how to create a dependent dropdown list then you must learn to create data validation drop down list from named ranges.
I’ve covered a few videos on dropdown list you can check them here:
How to Create a Drop-Down List in Excel Using Data Validation: https://youtu.be/SlyDv9R6RVY
How To Create Drop Down List and Display Different Values in Excel: https://youtu.be/h5s4Vzf1u_c
For this to work you need to understand named ranges and here is how: https://youtu.be/ax87ihcfH3E
Now that you’ve Learned to create dropdown list and named range lets learn how you can you them together. One of the greatest features of named ranges is you can add it to the dropdown list. In this tutorial I’ll show you how. Follow the instructions below.
Step 1: Create a named range from the data range you want inside your drop down list.
Step 2: Select the Cell or range where you want to place the dropdown list.
Step 3: Click on Data Tab and then Data Validation.
Step 4: Select “List” from the validation criteria Allow Drop Down
Step 5: In the range box write = and then the Name of your named range
Step 6: Click ok and done.
Done. You’ve just created a Dropdown list using the named range

#NamedRange #DataValidation #DropDownList

Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

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