Create A Data Validation 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. Add an input message.
From the allow drop down list choose list click in the source box and type an equal sign and the list name for example. The keyboard shortcut to open the data validation window is alt a v v. 1 create a drop down list in excel we can create a drop down list in excel using the data validation in excel tool so as the word itself says data will be validated even before the user decided to enter.
You ll want to select list in the drop down menu under allow.
The data validation window will appear. To create a drop down list start by going to the data tab on the ribbon and click the data validation button. On the settings tab define the validation criteria according to your needs. Open the data validation dialog box.
