Create Drop Down List In Excel 2016 For. Then drag the Fill Handle in the D2 down to D9 to fill the range D3D9. On the Data tab in the Data Tools group click Data Validation.
In the Data Validation dialog box select the Settings tab and then choose the option List in the allow dropdown list and also select the list of values that you want to use as source. If you want you can prepare the content of drop-down list in. Enter a letter C into the drop down box you will see all cells containing C are filled with number 1.
Here are the steps to create a drop-down list in Excel.
Creating the Drop Down List in Excel. Select List and Link the Data. In name input box enter a name for named range Here I am using monthList2003. You can find and double-click a saved Excel file on your computer or open Microsoft Excel and create a new.