How to Randomize a List in Google Sheets(Quick & Easy Guide)

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

How to Randomize a List in Google Sheets

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 :

Excel Tip How To Generate Random Od...
Excel Tip How To Generate Random Odd Or Even Numbers

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 )