Table of Contents
Google Sheets has a powerful function to randomize a list in just a few clicks. This function, called RANDOMIZE, will take your existing list and scramble the order of the cells randomly. This function can be used for a variety of applications, including generating random numbers, creating random teams, and shuffling rows. With the help of the RANDOMIZE function, you can quickly and easily randomize any list in Google Sheets.
Often you may want to randomize the values in one or more lists in Google Sheets.
Fortunately this is easy to do and the following examples show how to do so in different scenarios.
Example 1: Randomize One List in Google Sheets
Suppose we have the following list of basketball team names in Google Sheets:
To randomize this list, first highlight all of the team names, then click the Data tab and then click Randomize Range:
This will automatically randomize the list of team names:
Note: Be sure not to select the column header (“Teams”) or else this header value will also be randomized.
Example 2: Randomize Multiple Lists in Google Sheets
Suppose we have the following list of basketball team names and their number of points scored:
To randomize this list and keep the teams matched with the correct number of points, first highlight both columns, then click the Data tab and then click Randomize Range:
This will automatically randomize the list of team names but it will keep each team matched with their original number of points:
The following examples show how to perform other common operations in Google Sheets: