How to Randomize a List in Google Sheets

To randomize a list in Google Sheets, you can use the RAND function to generate random numbers and then sort the list based on these random numbers. Here's how to do it:

  1. Open your Google Sheets document containing the list you want to randomize.
  2. Make sure there's an empty column next to the column containing your list. If not, insert a new column by right-clicking on the column header and selecting "Insert 1 right" (or "Insert 1 left").
  3. In the empty column, next to the first item of your list, type the following formula:
  1. Press Enter to generate a random number.
  2. Drag the fill handle (the small square at the bottom-right corner of the cell) down to fill the entire column with random numbers corresponding to each item in your list.
  3. Select both columns (the one with your list and the one with the random numbers) by clicking on the first column header and dragging to the second column header.
  4. Click on "Data" in the menu bar, and then click on "Sort range by column...".
  5. In the "Sort range" window, select the column containing the random numbers (Column B, for example) from the "Sort by" dropdown menu.
  6. Make sure "A → Z" is selected for the sorting order, and check the box next to "Data has header row" if your list has a header.
  7. Click "Sort" to randomize your list based on the random numbers.


Here's an example of randomizing a list of names in Google Sheets:

  1. Suppose you have a list of names in Column A, like this:
  1. Follow the steps above to generate random numbers in Column B:
Alice 0.32145
Bob 0.78544
Carol 0.14632
Dave 0.65874
  1. Sort the range by Column B:
Carol 0.14632
Alice 0.32145
Dave 0.65874
Bob 0.78544

Now the list of names in Column A has been randomized.

Did you find this useful?