How to Create drop down list of cell in excel

By | June 27, 2020

Steps:

  1. Enter name in each row of excel, for which you want to create list, e.g. as below,
Fig 1

Fig 1

2. Go to Data tab in excel sheet and click on data validations as highlighted below,

data validations in excel

Fig 2

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]

Fig 3

Fig 3

4) drop down list of cell in excel is created.