In this tutorial, you will learn How to Randomize a List in Google Sheets
How to Randomize a List in Google Sheets: Step-by-Step Guide
Here are the steps to Randomize a List in Google Sheets :
Step 1 :
Open Google Sheets with an existing list of data or create a new list.
In this example, we will use the below list.
Step 2 :
- Choose the range which you want to randomize without selecting the header.
- You need to select a minimum of two rows as randomization will be done based on rows . You can select any number of Columns.
Step 3 :
Go to the Data menu on the Main menu bar and Select “Randomise range” as shown below
Step 4 :
The rows which you have selected will be sorted in a random manner. Keep in mind if there are any blank rows it will be moved to the end of the list.
Step 5 :
If you need to generate another random list simply choose the data-> to randomize range option again-
How to Randomize a List in Google Sheets(Conclusion)
In the above tutorial we have walked you through a step by step guide to to Randomize a List in Google Sheets.
We hope this tutorial on How to Randomize a List in Google Sheets was helpful.
Related articles :
How to Insert Spin Button in Google Sheets ( Easy Guide )
How to Freeze Rows in Google Sheets
How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)
How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )