Excel Data Validation Drop Down List. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. Add a drop down list to the selected cells the data validation dialog box displays.
The data validation window will appear. Go to the data tab on the ribbon then click data validation. Add a drop down list to the selected cells the data validation dialog box displays.
On the data tab in the data tools group click data validation.
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. 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. On the data tab in the data tools group click data validation. Empnames or press the f3 key to see.