Data validation drop-down lists in Excel adopt the same order as the source. In this example, to order the nations alphabetically, you would need to sort the source data by column B.

Figure A We’ll add a data validation control to this sheet. Click the Data tab, and then, click Data Validation in the Data Tools group. In the resulting dialog, choose List from the Allow dropdown.