How To Randomize A List In Excel?

Add a new helper column next to your list

Enter `=RAND()` in the first cell of the helper column

Fill the formula down for all rows in the list

Select both the list and the helper column

Sort the data by the helper column from smallest to largest

Delete the helper column if you no longer need it

Use `=RANDBETWEEN()` if you want random integers instead of decimal values

Use `Sort & Filter` or `Data > Sort` to perform the shuffle

Press `F9` to recalculate and reshuffle if the sheet uses volatile random formulas

Suggested for You

Trending Today