Shuffle data in Google Sheets

Power Tools provides you with a set of add-ins to speed up most of your daily tasks in Google Sheets. Shuffle is one of those utilities. It will help you randomize cells, rows, and columns in your Google spreadsheet.

How to use the Shuffle tool

Start the add-on

  1. Select the range with the values you want to randomize in your sheet.
  2. Go to Add-ons > Power Tools > Randomize in the Google Sheets menu:
    Start Power Tools from the Google Sheets menu.
  3. Click the Shuffle icon to open the tool:
    Find the add-on's icon in Power Tools.

How to shuffle cells, rows, and columns in Google Sheets

You can choose one of five ways to sort values at random:
Choose the way to randomize your data.

  • To shuffle records within the selected rows independently, select Cells in each row.
  • Pick Cells in each column to randomly sort entries within each column.
  • Choose Entire rows to keep data in the rows intact and randomize only the row order.
  • If you select Entire columns, the add-on will shuffle the order of the selected columns only.
  • Click on All cells in the range to have all selected values mixed randomly.

Once the shuffling mode is selected, click on the Shuffle button to randomize values within the selected range.


i have 4 cells in 2 rows like this:
[player x] [24]
[player y] [18]

the first row have a red background and the second row have a yellow background.
I want to switch between the two rows *including* their background so i will look like this:
[player y] [18] (with yellow background)
[player x] [24] (with red background)

help me please!! thank you


Hello Reut,

I'm sorry, the add-on can process only values at the moment. We are currently working on fixing this for one of the next versions, but I can't give you any timing.
If you'd like, we can let you know when the feature is available.


Is there a way to use the randomizes with rules? I am trying to shuffle our team’s schedule. One member of our team will always have a higher probability of being placed as she has six combinations but I don’t want her to be place too many times in a row.


Hello Jeremy,

Thank you for your question. Sorry, but our Shuffle tool randomizes your data in a totally random way. It is not possible to set any rules or priorities in the current version of the add-on.


Thanks for the power tools tutorial. Worked perfect for me.


Thank you for your lovely feedback, Jude! 🙂

Whesley Smart says:
February 14, 2020 at 9:54 am

Can this be done via mobile? When I do click add-ons it gives me 6 other apps to in-store but don't tell me what I actually need.

Katerina Bespalaya says:
February 14, 2020 at 12:27 pm

Hello Whesley,

Thank you for your question. Please note that our add-ons were designed to work in the desktop browsers (Chrome, Firefox, Safari on a Mac). If you open Google Sheets in a mobile browser, we can't guarantee that our add-ons will work there since we do not support mobile platforms.


Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.