Shuffle a list of numbers / items in excel spreadsheet

Here is a quick Monday tip for data junkies.

If you want to shuffle a list of numbers or cells in excel in random order you can do that with “data > sort” menu option of excel.

• First insert a column next to the list you want to shuffle and enter random numbers in each cell in using =rand(). See below:
• Now select the entire list and sort it by the new column with random numbers. (Menu > data > sort)
• If you want a fresh set of shuffled list, just hit f9 (recalculates all formulas) and sort again

Like this? Also learn how to sort horizontally, fill only weekdays while auto-filling dates