How do you make a random list in Microsoft Excel 2007? Well, one way to go about it is as follows. First we have our list.
In the column next to it, put a =rand() into every cell.
This is the random number function, which generates a random number between 0 and 1.
Next, highlight both columns. Sort by the random numbers column and that's it!
Your list has been randomized!