Excel Data Validation Drop Down List. Add a drop down list to the selected cells the data validation dialog box displays. 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.
The data validation window will appear. Go to the worksheet and click in the cell where you want the drop down list to appear. From the allow drop down list choose list click in the source box and type an equal sign and the list name for example.
However do not include the header cell.
Add a drop down list to the selected cells the data validation dialog box displays. Empnames or press the f3 key to see. Select a cell in which you want the dropdown to appear d3 in our case. On the settings tab you can have excel restrict entries in the selected cells to dates numbers decimals.
