- Enter name in each row of excel, for which you want to create list, e.g. as below,
2. Go to Data tab in excel sheet and click on data validations as highlighted below,
3. In data validation pop-up, Select list from allow dropdown and Select source =$B$5:$B$9 [rows of values for which you want to crate list ref fig 1, i have enter data in B5 to B9]
4) drop down list of cell in excel is created.