Shuffle and select randomly in Excel

Randomize lists and select random samples

With Random Sorter you can randomize cells in each row and column individually, re-sort all cells in the selected range, or shuffle entire rows and columns. You can also get a random selection from a set of data, for example, select random names or numbers from a list.

Learn more
This tool is part of
Ultimate Suite
Shufle & Randomly select for Excel 2016 - 2007

With Random Sorter you will

  • Randomize cells in each row or column Rearrange cell values within each column or row.
  • Randomize entire rows or columns Intermix whole rows or columns in the selected range.
  • Shuffle data between all cells in the range Randomly sort all cells in the selected range.
  • Select individual cells randomly Pick a number or percentage of random rows, columns, or cells.

How to randomize in Excel

  
Whenever you want to sort in Excel randomly…
Whenever you want to sort in Excel randomly…
…you can shuffle cells within each column or row…
…you can shuffle cells within each column or row…
…or randomize entire columns and rows
…or randomize entire columns and rows
There's also an option to mix up all cells in the selected range
There's also an option to mix up all cells in the selected range
You can also select any number or percentage of rows, columns, or cells randomly
You can also select any number or percentage of rows, columns, or cells randomly
Whenever you want to sort in Excel randomly…
…you can shuffle cells within each column or row…
…or randomize entire columns and rows
There's also an option to mix up all cells in the selected range
You can also select any number or percentage of rows, columns, or cells randomly

License benefits

Our customers get

Unconditional 30-day money-back guarantee
Secure payment
guarantee
Life-time license,
no additional fees ever
Volume discounts: the more you buy, the less you pay
1 license
for 2 computers
Free life-time support
Learn more
  • This tool is part of Ultimate Suite
  • 60+ professional tools. No garbage.
Buy now
  • Buy as part of Ultimate Suite
  • 60+ professional tools. No garbage.

These companies choose Ablebits products

   

Frequently asked questions

About Random Sorter

  • What is Random Sorter and what do I need it for?

    The add-in is designed to shuffle values in rows, columns, or all cells in a selected range. What's more, it can pick a random number or percentage of cells from your Excel spreadsheet.

  • Isn't there a way to sort and select randomly in Excel without any add-ins?

    Yes, there is a way. First, you insert a new column next to the column you want to randomize. Then, you populate your helper column with random numbers by using the RAND() function. After that, you sort the column with random numbers, and then select the required number of cells. If your knowledge of Excel formulas is above average, you can combine a few different functions together to select a random sample without duplicates. The downside of this approach is that new random numbers are generated with every recalculation of your worksheet, causing your random sorting and selection to change.

    Our add-in lets you shuffle your data and select randomly exactly the way you want, without messing around with volatile Excel functions.

  • How do I work with Random Sorter?
    1. To randomize data in Excel, do the following:
      • Run Shuffle Cells.
      • Select the range.
      • Choose how to randomize values.
      • Click Shuffle.
      See a more detailed description here.
    2. To select random cells in Excel, do the following:
      • Run Select Randomly.
      • Select the range.
      • Choose how many rows, columns, or cells you want to pick randomly.
      • Click Select.
      See a more detailed description here.
  • Won't I lose my data if I use the add-in?

    No, the add-in doesn't delete anything. On the contrary, it backs up your original worksheet whenever you need.

Supported versions

 

Excel

  • Excel 2019
  • Excel 2016
  • Excel 2013
  • Excel 2010
  • Excel 2007
  • 32-bit and 64-bit
  • Desktop Excel included in Office 365
  • Desktop Excel included in Office 365 ProPlus

Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7
  • 32-bit and 64-bit
Free download
14-day trial version
  • Included in Ultimate Suite for Excel
  • 14-day fully-functional version

Any questions or comments?

Please contact us here

Our working hours:
12:00 am - 10:00 am PST; 3:00 am - 1:00 pm EST; 8:00 am - 6:00 pm CET.
Excel add-ins and Outlook tools - Ablebits.com