Drop Down List Excel 2016. To create your own drop down list for the cell do the following. Step 1 open the excel spreadsheet file you want to edit.
Create a column or a row of the items in the active spreadsheet for the drop down list. Just include the cells that should appear in the drop down. Step 1 open the excel spreadsheet file you want to edit.
Insert drop down list in excel 2016 select the range of cells where you want to display the drop down list.
To create your own drop down list for the cell do the following. You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column. Firstly open your excel workbook in microsoft excel 2016 and then create a list of data that you want to insert in the drop down list. In name input box enter a name for named range here i am using monthlist2003.
