How to Randomize a List in Google Sheets

Google Sheets can shuffle a list into random order, pick random entries, or generate random numbers, which is useful for raffles, assigning groups, sampling survey responses or creating quiz orders. The quickest tool is Randomize range: select the cells you want to shuffle (without the header), then click Data > Randomize range, and Google Sheets shuffles the rows in place. Formulas like RAND, RANDARRAY and SORTN give you more control.

Online spreadsheet with a list of names selected and the Data menu open showing Randomize range highlighted
Data > Randomize range shuffles the selected cells.

Method 1: Randomize Range (Shuffle in Place)

  1. Select the cells to shuffle. To keep rows together, select all the columns in those rows (for example A2:C50).
  2. Click Data > Randomize range (or right-click > View more cell actions > Randomize range).
  3. Repeat to shuffle again.

This permanently reorders the data, so make a copy or use Undo (Ctrl + Z) if needed.

Method 2: Shuffle With a Formula (Original Stays Intact)

To create a shuffled copy in another column, use:

=SORT(A2:A50, RANDARRAY(ROWS(A2:A50)), TRUE)

For several columns: =SORT(A2:C50, RANDARRAY(ROWS(A2:C50)), TRUE).

Method 3: Pick Random Entries

  • One random item: =INDEX(A2:A50, RANDBETWEEN(1, COUNTA(A2:A50)))
  • Several unique random items (e.g., 5 winners): =ARRAY_CONSTRAIN(SORT(A2:A50, RANDARRAY(ROWS(A2:A50)), TRUE), 5, 1)
  • Random sample of rows: =SORTN(A2:C50, 10, 0, RANDARRAY(ROWS(A2:C50)), TRUE) returns 10 random rows.

Method 4: Generate Random Numbers

  • =RAND(): a decimal between 0 and 1.
  • =RANDBETWEEN(1, 100): a whole number from 1 to 100.
  • =RANDARRAY(10, 1): a column of 10 random decimals.

Classic shuffle trick: put =RAND() in a helper column next to your data, then sort the range by that column (Data > Sort range).

Stop Random Results From Changing

RAND, RANDBETWEEN and RANDARRAY recalculate every time the sheet changes. To lock in results:

  1. Select the formula results and press Ctrl + C.
  2. Right-click and choose Paste special > Values only (Ctrl + Shift + V).

You can also control recalculation in File > Settings > Calculation, but random functions still update on edits.

Common Uses

  • Raffles and giveaways: shuffle entries and take the top rows. Record the result by pasting values.
  • Random groups: shuffle a class list, then assign groups by position.
  • Quiz order: shuffle questions for each version of a test.

Other Things People Ask About Randomizing

Why don’t I see Randomize range?

Select a range first; the option appears when cells are selected. It’s available on the web version, not all mobile apps.

Is it truly random?

It’s pseudo-random, which is fine for classroom or casual use but not for regulated lotteries.

Can I randomize in Excel?

Yes. Excel 365 supports =SORTBY(A2:A50, RANDARRAY(ROWS(A2:A50))).