How to use Random Generator for Excel

The Random Generator add-in lets you quickly populate the selected cells with random records of any chosen type. With this tool, you can create random numbers without duplicate records, randomize values from your custom list, or obtain secure passwords.

So, pick your task and let's get started.

Start Random Generator

Run the add-in from the Randomize tool in the Utilities group on the Ablebits Tools tab:
Run Random Generator in Excel.

You will see the Random Generator pane:
Random Generator for Excel.

By default, the tool selects the entire data range in your sheet. You can change the range by choosing it in your table manually, entering the address into the range area using your keyboard, or by clicking the Expand selection icon (blue in the screenshot above) to get the whole table highlighted automatically.

Note. If you select the range with data, the add-in will always ask if you really want to remove the existing entries and replace them with the newly created random values.

To start adjusting the options, expand the group of interest on the Random Generator pane.

How to generate random integers

  1. Click on the Integer group to expand it:
    Expand the first group to generate integers.
  2. Define the minimum and maximum integers in the From and To fields. You can type in the required values manually or set them by clicking the up and down arrows in the fields.
  3. If you need random values without duplicates, tick the Unique values checkbox and all the created numbers will be different. You can generate unique random integers from -2147483648 to 2147483647.
  4. Click on the Generate button to fill your range with random integers.

How to create random real numbers in Excel

  1. Open the Real section by clicking on it:
    Generate real numbers.
  2. Set the minimum value in the From field and the maximum value in the To field. Enter the required values manually or set them by clicking the up and down arrows in each field. You can generate random real numbers from -99999999.9 to 99999999.9.
  3. If you need to make sure your random real numbers don't have repetitions, tick the Unique values checkbox and all the generated values will be different.
  4. Click Generate to fill your range with random real numbers.

How to fill the range with dates at random

  1. Click on the Date section to expand it:
    How to randomize dates in Excel.
  2. Select the initial and final dates in the From and To fields. You can enter the values manually or use the built-in calendar. To open the calendar, click the arrow in the From or To field respectively.
    The add-in's drop-down calendar.

    Tip. Click the month name to switch to the year view; click the year to get the decade view.
  3. You can get workdays and weekends generated separately. If you want to create only workdays, tick the Workday checkbox. If you want to fill the range with weekend days only, tick the Weekend checkbox. Pick both options to generate weekends and workdays at the same time.
  4. If you need to generate completely different random dates, tick Unique values.
  5. Click on the Generate button to fill your range with random dates.
    Tip. If the created values don't appear as dates, please change the format of the cells using the standard Excel's Format Cells... option.

How to generate Yes/No or True/False Booleans

  1. Expand the Boolean section by clicking on it:
    Create random Booleans in Excel.
  2. To select a Boolean, click the arrow in the Value field and select the necessary group from the drop-down list. You can generate true/false or yes/no values.
  3. Click on the Generate button to fill your range with random Booleans.
Tip. If you want to change the random values in the selected range, just click Generate again and these Booleans will be automatically replaced with new values.

How to create a custom list of names, numbers, etc.

  1. Expand the Custom list section in the Random Generator pane:
    Generate random values from your custom list.
  2. You will see several standard Excel custom lists as well as the ones you created. Click on the list you need to choose it.
    Tip. To add your custom list, select the range with the needed items in your worksheet: it can be a column, row, or a block of cells with data, and then click the New list button. Confirm your choice by clicking OK in the dialog box.
    Tip. To remove a custom list, select it in the pane and click Delete. Also, you can right-click the custom list and choose Delete in the context menu.
  3. If you want to have random custom list values without duplicates, tick the Unique values checkbox and all the generated values will be different.
  4. Click Generate to fill your range with random values from your list.

How to generate passwords in Excel

  1. Select a range that you want to fill with random passwords in your Excel worksheet and expand the String section in Random Generator:
    Generate random passwords in Excel.
  2. Specify the character set(s) you want to use. There are letters in upper and lower case, numbers, space, certain characters like punctuation marks with some commonly used symbols, and Hexadecimals that you can choose from.
  3. If you need to generate random password strings with certain characters only, check the Custom box and type or copy/paste these chars. You can use this option alone or in combination with other character sets.
  4. Select the String length option to set the number of chars for the generated passwords. You can enter it manually or select it by using the up and down arrows. The strings can be from 1 to 99 characters long.
  5. Click the Generate button.

How to fill cells in Excel with random strings

If you need random alphanumeric strings, codes, random text, or other string data, use the String section in the Random Generator pane.

  1. If you need random alphanumeric strings, codes, random text, or other string data, click the String section to open it:
    How to generate random strings in Excel.
  2. Choose the necessary character set(s): letters in upper and lower case, numbers, space, certain characters like punctuation marks with some commonly used symbols, Hexadecimals, and/or Custom characters.
  3. If you need to pre-specify your codes, SKUs, or IDs, take advantage of the By mask option to set the pattern. A question mark (?) stands for one character. E.g. if you need to get a string like "F0E3-AD27-53A0", use the following mask "????-????-????".
    Tip. You can also have constant symbols in your strings when generating them by mask. Here is an example: you want the first 3 characters in the strings to be "000", so all you do is type in this mask: 000-????-????
  4. You can also use one of the default templates. Click the arrow in the By mask field to select one of the suggested patterns.
  5. Click on the Generate button and get your random data strings: passwords, codes, IDs, and so on.

Responses

Once I have installed the Random Number Generator feature can it be embedded into a PowerPoint presentation? I want to randomly generator (4) numbers, four different times during a presentation. I will have Wi-Fi access to the internet if needed.

Does this product require an active connection to the Internet (once installed) to use it, or can I use it off-line where there is no Internet access? Thank you!

Hello Dennis,

Thank you for your question.

Please note that the Random Generator tool is available as a part of Ultimate Suite for Excel. You need the Internet connection for downloading and activating the add-in. Internet access is not required for installing and using the tools.

Feel free to install Ultimate Suite in a trial mode and check how the tool works. Here is the direct download link for you:
https://www.ablebits.com/files/get.php?addin=xl-suite&f=free-trial

If you have any questions or need some assistance with the add-in, please email us at support@ablebits.com.

Jiri Staats says:
March 18, 2021 at 2:30 pm

Hi there,
Is there a way to create a random unique strings? I'm trying to generate 3 millions codes with 5 digits (letters and numbers).
Also, Excel rows is limited to around 1 million, and I can't seem to remove duplicates spread over different columns. Is there a workaround for this?

Thanks

Hi Jiri,

Thank you for your question. Please try to select a range that contains more than 3 million cells, use Random Generator to fill them in with random strings, and apply the Find Duplicate Cells tool to eliminate duplicate entries. For detailed instructions on how to work with Find Duplicate Cells, please visit our help page.

If you have any other questions, feel free to email us at support@ablebits.com

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.