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.