To edit a drop-down list in Excel, you can use a number of tools depending on how you created the list. Here's what you need to know.

While the Office apps can't do that, RandomizeList accomplishes your needs in a jiffy. Just copy and paste the names one below the other in the box provided on the site and hit 'Randomize'.