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 :

Open Google Sheets with an existing list of data or create a new list.

In this example, we will use the below list.

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.

Go to the Data menu on the Main menu bar and Select “Randomise range” as shown below

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.

If you need to generate another random list simply choose the data-> to randomize range option again-

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.