Random Generator for Microsoft Excel

Generate non-repeating numbers and dates at random

Random number generator for Excel

This tool lets you quickly populate the selected cells with random records of any selected type. You can run the Random Generator add-in from the Randomize tool in the Utilities group under Ablebits Tools tab.

Click on the section with the kind of records you want to get in your Excel table in the add-in pane:

Free Download
7-day fully functional version

How to generate random integers

  1. Select the range that you want to fill with integers in your worksheet or enter its address at the top of the add-in pane.
  2. Define the minimum and maximum integers in the From and To fields. You can manually type in the required values, or you can set the values by clicking the up and down arrows next to the fields.
  3. If you need random values without duplicates, tick the Unique values checkbox and all the generated numbers will be different. You can generate from -2147483648 to 2147483647 unique random integers. Click on the arrows to expand the Integer section
  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 in the Random Generator pane by clicking on it.
  2. Set the minimum value in the From field and the maximum value in the To field. You can manually enter the required values or you can set the values by clicking the up and down arrows next to the From and To fields. You can generate from -99999999.9 to 99999999.9 random real numbers.
  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. Expand the Real section by clicking on the arrows
  4. Click on the Generate button.

How to fill the range with dates at random

  1. Choose a range that you want to fill with dates in your Excel worksheet. Expand the Date section in the Random Generator pane.
  2. Select the initial and final dates in the From and To fields.
  3. You can enter the values manually or use the built-in calendar. To use the calendar, click the down arrow next to the From or To field respectively.
  4. 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. Tick both options to generate weekends and workdays at the same time.
  5. If you need unique random dates, tick the Unique values checkbox and all the generated dates will be different. You can generate unique random dates from 01.01.1900 to 31.12.2100. Clicking on the arrows will expand the Date section
  6. Click on the Generate button to fill your range with random dates. If the generated values don't appear as dates, please change the format of the cells using the standard Excel Format Cells… option.

How to generate Yes/No or True/False Booleans

  1. Expand the Boolean section in the Random Generator pane by clicking on it.
  2. To select a Boolean, click the down arrow next to the Value field and select the necessary value from the drop-down list. You can generate true/false or yes/no values. Expand the Boolean section using these arrows
  3. Click on the Generate button to fill your range with random Booleans.

If you want to change the generated random values in the selected range, just click Generate again and these Booleans will be automatically replaced with new values.


See also

 
Contact us
 
  Publish your message on our support forum
 

Our working hours: 0am to 10am PST; 3am to 1pm EST; 8am to 6pm CET.

Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard
 
 
Excel add-ins and Outlook tools - Ablebits.com