Random Generator for Microsoft Excel

Fill the range with random values from an Excel custom list

How to fill the range with random values from a custom list How to create a new custom list How to delete a custom list How to create worksheets named after custom list values How to pick some values from a custom list Back to Random Generator Overview
15-day fully-functional version, 9.3 MB

Select a range that you want to fill with custom list values in your worksheet. Click here to see how to select a range.
Expand the Custom list section on the Random Generator pane by clicking on the arrows next to Custom list.
You will see several standard Excel custom lists. Select the necessary list by clicking on it.
If you need unique random custom list values, tick the Unique values checkbox and all the generated values will be different.
Tip: If you want to have a look at all the items on the list, click the "+" button next to it or simply double-click on the list, and then scroll through the values.
Click on the Generate button to fill your range with random custom list values..
If you want to change the generated random values in the selected range, just press Generate again and they will be automatically replaced by new ones.

Tip: If there are more cells in the range than generated unique values, some of the cells will be empty.

You can add your own custom list to the custom list section.
To add your custom list, select the range with the list in your worksheet. It can be a column, row or a block of cells with data.
Then press the New list button.
Confirm your selection by clicking the OK button in the Select Range Dialog box.
Your new custom list will be listed among others under Custom list section.

You can remove a custom list from the Custom list section if you need.
To do it, select a custom list you want to remove and click the Delete button.

Note! You can't delete standard Excel custom lists.

Custom list section makes it possible for you to create worksheets and give them custom list value names.

To create worksheets named after custom list values, select the custom list with the values you need. Then click on the Create worksheets button.
After that you will get as many worksheets as there are values in the custom list you selected. These worksheets will take the names of the custom list items.

If you have 30 names in your custom list, you may want to pick out just 10.

In your worksheet select a range that you want to fill with some of the custom list values. Click here to see how to select a range.
Expand the Custom list section on the Random Generator pane by clicking on the arrows next to Custom list.
Select the necessary custom list, click the "+" button next to it or double-click on the list to see all the items it contains.
Holding the Ctrl key on your keyboard, select the values from the custom list that you want to use in the selected range.
Click on the Generate button .
If you need to fill the range with unique values you chose from the custom list, check the Unique values checkbox and all the generated values will be different.
If you want to change the generated random values in the selected range, just press Generate again and these values will be automatically replaced by new ones.

Note: If there are more cells in the range than unique values, some of the cells will be empty.

Your Name*
Your e-mail*
Subject
Message*
	Please remember that we work from 9am to 6pm GMT this is 5:00am - 2:00pm EST, 2:00am - 11:00am PST and our public holidays may differ from yours.