Category Archives: Excel

How to Create drop down list of cell in excel

By | June 27, 2020

Steps: 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… Read More »