Data Validation Excel Drop Down List. Click the source box select your list range and select ok. Go to the data tab on the ribbon then click data validation.
Data validation lists are a great way to control the values that are input in a cell. However do not include the header cell. If you already made a table with the drop down entries click in the source box and then click and drag the cells that contain those entries.
For this example we want to add drop down lists to the.
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. However do not include the header cell. Go to the worksheet and click in the cell where you want the drop down list to appear. Turn on data validation for selected cells.
