Shuffle cells in rows, columns, or in the selected range with the Shuffle Cells tool in a couple of clicks.
We care about your data. We recommend keeping the Back up this worksheet option selected so that original table remains intact.
Please note, the tool won't process several ranges or non-adjacent cells - only one range of adjacent cells.
Run Shuffle Cells from the Randomize tool, Utilities group on the Ablebits Tools tab in Excel:
Once the tool is running, you'll see the add-in pane:
Click the Shuffle button, and your data will be randomized within the selected range.
how to create random email and mobile number using this.
Please help me out soon
Thank you for your message. I have just sent you a video instruction in a separate email. Please check you Inbox.
Hi. I have a range of 1 to 15, and need to randomize a selection of 5 numbers in that range. I have tried all of the various functions in the randomizer, including the string, and cannot figure it. Is this possible? Please help!
Thank you for contacting us. I'm sorry, I am sorry but your task is not entirely clear. Can you please specify? If you send us a small sample workbook with your source data and the result you expect to get to email@example.com, it'll help a lot. Thank you.
How is one able to randomise colums without , switching to .
The Data program which I use afterwards is not able to use commas as delimiters.
I appreciate any ideas ! Thank you
Thank you for contacting us.
I'm sorry, but your task is not entirely clear. For us to be able to understand it better, please send us a small sample workbook with your source data and the result you expect to get to firstname.lastname@example.org. Just about 10-20 rows will be enough.
We'll look into your task and see if our software can help.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!