Drop Down List Excel 2016. Go to formulas defined names name manager click new. On the data tab in the data tools group.
Make sure to enter each drop down entry in a separate consecutive cell in the same column. Now you have a dynamic range monthlist2003 and you can use this range name to create a dynamic drop down list. Create a column or a row of the items in the active spreadsheet for the drop down list.
Enter below formula in refers to and click ok.
In name input box enter a name for named range here i am using monthlist2003. Make sure to enter each drop down entry in a separate consecutive cell in the same column. Just include the cells that should appear in the drop down. In this example let s have the sheet2 s cell a3 to a7 contain the list items.
