Data Validation Drop Down List Excel. You ll want to select list in the drop down menu under allow. If you need to see the full list select full list from the top of the drop down list and then click the drop down arrow again.
Select a cell where you want to insert data validation. Turn on data validation for selected cells. Show more than 8 lines in data validation list with combo box the combo box can help you showing more than 8 lines in drop down list in excel.
To create a drop down list start by going to the data tab on the ribbon and click the data validation button.
The data validation window will appear. On the source click on range selection button select your list range click ok. The data validation window will appear. We are now going to tell excel to use the named range we created to populate the list.
