Data Validation Drop Down List Excel. 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. Create the drop down list select the cells in which you want the drop down list on the ribbon s data tab click data validation.
From the allow drop down list choose list click in the source box and type an equal sign and the list name for example. For this example we want to add drop down lists to the. You ll want to select list in the drop down menu under allow.
If you can t click data validation the worksheet might be protected or shared.
Enable the developer tab then click insert combo box. Turn on data validation for selected cells. For this example we want to add drop down lists to the. If the cell does not contain the text full list the drop down will show the short list of top customers.
