How to Randomize Rows in Excel (Reproducibly)
Assigning people to groups or shifts, randomising a running order, blinding a review so the list is no longer alphabetical. The usual trick is a RAND() column and a sort — which works once, and can never be explained afterwards.
Last updated: October 2026
| Before | → | After (seed 42) |
|---|---|---|
| Ana, Ben, Cara, Dan | → | Cara, Ana, Dan, Ben |
| Same seed, run again | → | Cara, Ana, Dan, Ben |
Why the seed is the whole point
A shuffle nobody can reproduce is a shuffle nobody can audit. Three months later, when someone asks how the allocation was made, a RAND() column has no answer — the numbers that produced it recalculated away the moment the sheet was touched. With a seed, the same rows come out in the same order on any machine, and the method can be written down: "seed 42, in the order the list was in".
A proper shuffle, not a sort by random
Sorting by a random key is the common trick, and its fairness depends on the sort implementation and on no two keys colliding. This uses Fisher–Yates, which gives every possible ordering exactly the same probability — which is what "random" has to mean if the result decides who works which shift.
The 1-click way (Tellsheet)
Shuffle Rows
Select the rows and run Shuffle Rows. The header stays put, every row is kept, and the order is drawn from the seed you give — the same seed always produces the same order, on any machine, so the allocation can be re-derived later. The summary reports how many rows moved.
Frequently asked questions
Why not RAND() and sort?
It works once and cannot be reproduced or explained afterwards.
What does the seed do?
It fixes the order — the same seed always gives the same shuffle.
Is the header shuffled?
No, it stays where it is.
Is it a fair shuffle?
Yes — Fisher–Yates, so every ordering is equally likely.
Related Excel guides
Random, and explainable
Shuffle Rows gives a fair order you can reproduce from a seed.
Get Tellsheet free See pricing