In this article:

How to Shuffle Rows in Google Sheets (Easiest Way in 2024)

May 8, 2024

How to Shuffle Rows in Google Sheets

Follow the steps below to shuffle rows in Google Sheets. 

1. Add a New Column for Random Numbers

Next to your data (to the right of the "Favorite Color" column), add a new column. This column will be used for generating random values.

google sheets shuffle rows

2. Populate the New Column with Random Values Using =RAND()

Click on the first cell of your new column (if your dataset starts from the first row, this would be cell C1). Type ‘=RAND()’ and press Enter.

how to shuffle rows in google sheets

Then, drag the fill handle down through the column to apply this formula to all rows associated with your dataset which assigns a random number to each person.

shuffle rows in google sheets

3. Shuffle Rows by Sorting Based on Random Numbers

Highlight the entire dataset including the new column of random numbers. Go to the Data menu, select "Sort range," and choose "Advanced range sorting options".

shuffle rows google sheets

Tick the box next to "Data has header row" and select sort by Column C (or your new column), either in ascending or descending order. This will shuffle your rows based on the random numbers.

4. Remove the Column with Random Numbers After Shuffling

Now that your data is shuffled, you don't need the column with random numbers anymore. Right-click the header of the new column (Column C) and choose "Delete column".

5. Verify the Data to Ensure Rows Have Been Successfully Shuffled

Take a moment to review your data. The names and their favorite colors should now be in a randomized order.

We hope that you now have a better understanding of how to shuffle rows in Google Sheets. If you enjoyed this article, you might also like our article on how to change margins on Google Sheets or our article on coefficient of variation in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->