Last Updated on January 2, 2024 by Jake Sheridan
Generally when people think about the order of data in a spreadsheet, they want to sort that data in a specific way.
But you may also run into situations where you need to randomize a list in.
For example, if you want to create random break out or study groups for a meeting or class.
Instead of trying to randomize a list manually or relying on complex formulas to randomly select each entry from the sorted list, you can automatically randomize a range in Google Sheets quickly in just a few clicks.
How To Randomize A List In Google Sheets
Here’s how shuffle rows in Google Sheets:
Step 1) Access the randomization feature
Select the range you want to randomize, excluding headers.
Randomization is done based on rows, so you must select at least two rows, however you can select any number of columns
Step 2) Confirm the randomization
Open the Data menu and click on the Randomize Range option
Step 3) Repeat if necessary
The rows in the selected range will be sorted into a random order. Note that any blank rows in the range will be moved to the end of the list
You can repeat the process as needed to get a different random order of the rows in the selection
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to randomize a list in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to sort in Google Sheets:
- How To Sort
- Add Dates
- Format Dates
- Stop Google Sheets From Changing Dates
- Sort Alphabetically
- Auto Sort
- Arrange Numbers In Ascending Order
- Sort By Color
- Sort By Date
- Change Date Format
- Sort By Number
- Sort By Last Name
- Sort And Filter
- Sort Unique Values
- Sort In Google Sheets And Keep Rows Together
- SORTN Function