Learn how to create a drop down list in Excel, from simple yes/no lists to customizable lists that use named ranges. See the full article: https://www.vertex42.com/blog/help/ex...

0:15 Simple Yes/No Drop-Down List
1:36 Use a Range as a Source for the Drop Down in Excel
1:50 Use a Named Range for the Dropdown Source
2:20 Using Relative References in a Drop Down List

FOLLOW VERTEX42 HERE:
Instagram:   / vertex42  
Facebook:   / vertex42  
Pinterest:   / vertex42  
Twitter:   / vertex42  

LOOKING FOR MORE SPREADSHEETS? START HERE:
https://www.vertex42.com/ExcelTemplates/