Add a new helper column next to your list
Enter `=RAND()` in the first cell of the helper column
Fill the formula down for all rows in the list
Select both the list and the helper column
Sort the data by the helper column from smallest to largest
Delete the helper column if you no longer need it
Use `=RANDBETWEEN()` if you want random integers instead of decimal values
Use `Sort & Filter` or `Data > Sort` to perform the shuffle
Press `F9` to recalculate and reshuffle if the sheet uses volatile random formulas
