Randomly select data in your Excel file

Use the tool to get a random selection from a set of your Excel data range. It's also possible to specify the percentage and number of cells, rows, or columns you want to get from the entire selection.

How to randomly select values in a range

Pick the option to Select Randomly from the Randomize tool, Utilities group on the Ablebits Tools tab in Excel:
Click on the Select Randomly icon to run the tool.

The add-in offers you the following options:
Pick the options you need on the add-ins' pane.

  1. Your entire data range will be selected by default. Choose another range by highlighting it in Excel or entering it in this field.
  2. If you changed the range, highlight the entire table back by clicking the Expand selection icon.
  3. You can exclude header rows from the selection if there are any by checking My table has 1 header row.
    Tip. If there are more headers in your table, click on the "1 header row" phrase, enter the number of lines with labels, and they won't be selected:
    Let the add-in know how many header rows your table has.
  4. Expand the group with the option that suits you best:
    • You can select some number or percentage of random rows in your Excel table.
    • Pick random columns in your worksheet.
    • Or select some random cells in your range.
  5. Specify the number or percentage of rows, columns, or cells that you want to select. You can enter the necessary value into the percentage or number field respectively. Or set these values by clicking up and down arrows next to the fields.

Once options are chosen, click the Select button and get your datasets highlighted.

Responses

I follow these steps and nothing seems to happen except under "select randomly" the rows selected show up but they aren't filtered on the spreadsheet, not does a new tab show up with the selected rows. what am i missing?

Reply

Ok, figured out that it highlights the randomly chosen rows, but how do you get them grouped together by themselves?

Reply

Hello, Doug,

Thank you for using our tool and for your question.
Select Randomly neither filters the sheet by the selected rows, nor groups the randomly selected rows/columns/cells.
In fact, it simply selects random rows, columns, or cells (depending on the options you choose) so you could work with them as you need. If you need to get the randomly selected entries on a separate sheet, you will have to copy and paste them into a new Excel sheet manually.

Thank you.

Reply

This would be great if the cells stayed highlighted. The range changes and highlights disappear when you click back onto the spreadsheet. This makes it very difficult to filter or do anything with the randomly selected cells.

Reply

Hi, Ashlea,
Thank you for using the tool and for your feedback! Since this is quite a common request, I will pass it to our developers and hopefully, we will implement this feature in the coming releases.
Thank you.

Reply

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 support@ablebits.com.
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.