How to Randomize Range in Google Sheets

How to Randomize Range in Google Sheets. Built into Google Sheets is the ability to randomize a range without sorting the entire sheet. Alice Keeler shows you how.

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90

Warning: Undefined array key "background_image" in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 87

Warning: Trying to access array offset on value of type null in /www/teachertech_682/public/wp-content/plugins/elementor/includes/conditions.php on line 90
How to Randomize Range in Google Sheets

You can do so much with Google Sheets™. One feature I use a lot is randomizing in Google Sheets. For example, if I want to call on a student from a list of student names. It does not always make sense to sort the entire sheet, I just want to sort the part of the sheet that has student names. Sorting also would only sort alphabetically, not randomly. I will show you how to randomize range in Google Sheets.

Highlight the Range

What are you trying to randomize? The list of student names? Highlight all of the student names.

How to Randomize Range in Google Sheets by highlighting the range of student names and right clicking to choose view more cell actions and randomize range.

Right Click

The right click menu has changed recently. You will want to click on “View more cell actions” to find the “Randomize range” option.

Notice in my screenshot from the sample spreadsheet that I have “Student Names” in cell D4. I do not want to sort the words “Student Names” with my students. Highlighting D5 to D16 is only the names of the students. Choosing “Randomize Range” from the right click menu will sort ONLY the D5 to D16. The sort will obviously not be alphabetical, but random. This helps me to decide things like who is giving their presentation first.

Quiz Helper is a Free Add on
Install the FREE Add-on Quiz Helper by Alice Keeler. Collects NO user data.

© 2024 All Rights Reserved.

💥 FREE OTIS WORKSHOP

Join Alice Keeler, Thursday Oct24th or register to gain access to the recording.
Create a free OTIS account.

Join Alice Keeler for this session for using FigJam to start every lesson.

Exit this pop up by pressing escape or clicking anywhere off the pop up.