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.
Before you start
The Shuffle tool also processes cells in filtered & hidden rows & columns.
How to use the Shuffle tool
Start the add-on
- Select the range with the values you want to randomize in your sheet.
- Go to Extensions > Power Tools > Start in the Google Sheets menu:
- Click the Shuffle icon to open the tool:
How to shuffle cells, rows, and columns in Google Sheets
You can choose one of five ways to sort values at random:
- 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.
Responses
Meghedi says:
November 19, 2023 at 7:12 pm
I need assistance related to utilizing power tools which I activated already.
Still, the error message appears.
Dear Meghedi,
We apologize for the inconvenience caused by our add-on. Please contact us by email, support@ablebits.com, and specify which feature of the Shuffle tool you were using when the error happened? It would be helpful if you could attach some screenshots of the error message and the settings you chose in the tool.
RAJAT BHARTI says:
November 10, 2023 at 12:10 pm
Hi,
Can the shuffler works with some specific rules and shuffle the entire rows automatically whenever it see the order to be shuffled.
Hello Rajat,
Thank you for your question.
The Shuffle tool cannot process data automatically. You need to run the tool each time you want to shuffle rows.
Thank you.
Tom says:
April 23, 2023 at 10:01 pm
I dont have power tools option? Is it changed? I dont have any other way.
Hello Tom,
Thank you for your comment.
Could you please describe in more detail the problem you've faced? Any screenshots illustrating the issue would help a lot. Please send the details to support@ablebits.com.
We'll try to help. Thank you.
Jeff says:
August 29, 2020 at 7:52 am
Hi,
After using the shuffle tool on rows which have cells including dates
When trying to copy to another sheet they dates come up as numbers etc
43654
43644
42730
42037
40884
41662
42585
37441
43150
42104
as opposed to
23 Dec 2016
02 Feb 2015
07 Dec 2011
Is there any way to fix this?
Only seems to be an issue when I have used power tolls to shuffle
Hi Jeff,
Thank you for contacting us. For us to be able to help you better, please share a sample spreadsheet with your source data with us (support@apps4gs.com) so we might reproduce this issue on our side. When sharing, make sure the option 'Notify people' is checked. To grant us access to your data, press the Share button at the upper right corner of Google Sheets and enter support@apps4gs.com.
Note. We keep that Google account for file sharing only and don't monitor its Inbox. Please do not email there. Once you share the file, just confirm in this message thread.
If you have confidential information there, you can replace it with some irrelevant data, just keep the format.
We'll do our best to help.
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 (Ablebits Team) 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.
Jude Odele says:
January 16, 2020 at 12:45 pm
Thanks for the power tools tutorial. Worked perfect for me.
Thank you for your lovely feedback, Jude! :)
Jeremy says:
December 23, 2019 at 8:14 pm
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.
reut says:
April 17, 2019 at 8:27 am
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.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!
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 support@ablebits.com.
