Use Random Generator to Insert Random Numbers, Dates & Passwords in Excel 365!!
Tags: generaterandomvalues, kutoolsexceltutorial, kutools
Published: 2020-11-23 10:11:41

---
title: Use Random Generator to Insert Random Numbers, Dates & Passwords in Excel 365!!
published: true
date: 2020-11-23 06:20:55 UTC
tags: Generaterandomvalues,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/use-random-generator-to-insert-random-numbers-dates-passwords-in-excel-365/
---

In this article, we are going to see how to **Use Random Generator to Insert Random Numbers, Dates & Passwords in Excel Office 365** with **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Generate Random Numbers in a Range:

If you want to generate random numbers in a range, then do as follows.

- You need to **select the range** where you want to generate random numbers.
- Go to the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- It will open the **Insert Random Data Dialog Box**.
- In that dialog box, you need to **click** the **Integer Tab.**
- **From box –** You need to **enter** the **starting range.**
- **To box –** Here, you need to **enter** the **ending range.**
- Finally, **click** the **OK** button.

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-37.png)<figcaption id="caption-attachment-17863">Insert Random Data Dialog Box</figcaption>

- You will see the results in the selected range as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-36.png)<figcaption id="caption-attachment-17864">Result</figcaption>

## Insert Random Decimal Numbers in a Range:

To insert random decimal values in a range in Excel, follow the below steps.

- First, you need to **select the range** that you want to insert random decimal values.
- On the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu list.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- Then, it will display the **Insert Random Data Dialog Box**.
- You need to **click** the **Decimal Tab.**
- Then, you need to **specify the input range** under the **From** & **To** drop-down boxes.
- **Decimal place –** Here, you need to specify the decimal place.

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-32.png)<figcaption id="caption-attachment-17867">Insert Random Data Dialog Box</figcaption>

- finally, **click** the **OK** button to get the result as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-27.png)<figcaption id="caption-attachment-17868">Output</figcaption>

## Generate Random Date in a Range:

If you want to generate random dates into a range such as the date of workdays or weekends of a specified period of data, follow the below steps.

- You need to **specify the range** that you want to insert a random date.
- Go to the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- It will open the **Insert Random Data Dialog Box**.
- You need to **click** the **Date Tab.**
- Then, you need to **specify the start and end date** of a range in **From** & **To** text boxes.
- Then, you can **check** the **Workday** (it will generate all workday dates between the specified dates) or the **Weekend** (it will generate the weekend dates between the specified dates) option as you wish.

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-25.png)<figcaption id="caption-attachment-17869">Insert Random Data Dialog Box</figcaption>

- At last, you need to **click** the **OK** button to display the result as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-23.png)<figcaption id="caption-attachment-17870">Output</figcaption>

## Insert Random Time in a Range:

You can also insert the random time into a specified range, kindly do as below instructions.

- First, you need to **select the range** that you want to insert random time.
- On the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu list.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- Then, it will display the **Insert Random Data Dialog Box**.
- You need to **click** the **Time Tab.**
- Then, **specify the times** in the **From** and **To** text boxes.

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-22.png)<figcaption id="caption-attachment-17871">Insert Random Data Dialog Box</figcaption>

- Now, **hit** the **OK** button to see the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-20.png)<figcaption id="caption-attachment-17872">Result</figcaption>

## Generate Password or Specified Formatting Data Strings in a Range:

If you want to generate or insert random data strings in a range, do as below steps.

- First, you need to **select the range** that you want to generate data strings.
- On the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu list.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- Then, it will display the **Insert Random Data Dialog Box**.
- Then, you need to **click** the **String Tab.**
- You can **select** the **characters** and specify the **string length** using the drop-down list.
- Then, **click** the **OK** button.

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-17.png)<figcaption id="caption-attachment-17873">Insert Random Data Dialog Box</figcaption>

- Finally, you will see the inserted data strings as below screenshot shown.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-12.png)<figcaption id="caption-attachment-17874">Output</figcaption>

To insert specified formatting data strings in a range, do as follows.

- You need to **select the range** where you want to insert the formatting data.
- On the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu list.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- On the **String Tab** in the **Insert Random Data Dialog Box.**
- You need to **specify** the **characters.**
- Then, **check** the **By mask** option and specify the data string. For example, ???#.??.com

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-12.png)<figcaption id="caption-attachment-17875">Insert Random Data Dialog Box</figcaption>

- Now, **click** the **OK** button to get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-9.png)<figcaption id="caption-attachment-17876">Result</figcaption>

## Insert a Custom List in a Range:

You can also generate a custom list in cells by doing the following instructions.

- You need to **select a range** you need to insert the custom list.
- Go to the **Kutools Tab, select** the **Insert** option, then **choose** the **Insert Random Data** option from the menu.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-38.png)<figcaption id="caption-attachment-17861">Select the range</figcaption>

- It will open the **Insert Random Data Dialog Box**.
- Under the **Custom List Tab,** you can use the default custom lists or create a new custom list by clicking ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-insert-random-data-9.png) button.
- It will open the **Kutools for Excel Dialog Box** where you need to enter the custom data and **click** the **OK** button.
- Now, the custom listed is created, you need to **select it** and **click** the **OK** button.

![Insert Random Data Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-9.png)<figcaption id="caption-attachment-17877">Insert Random Data Dialog Box</figcaption>

- At last, the new values have been inserted into the specified range as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-7.png)<figcaption id="caption-attachment-17878">Result</figcaption>

### Note:

- **Unique values –** This option will generate or insert unique values in the range.

## End of the Article:

In the above article, you can clearly understand the steps to **Use Random Generator to Insert Random Numbers, Dates & Passwords in Excel Office 365** with **Kutools. ** Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Add the Same Text or Characters in a Range of Cells in Excel 365?](https://geekexcel.com/how-to-add-the-same-text-or-characters-in-a-range-of-cells-in-excel-365/)
- [Change Case of Text to All Caps, Lower and Proper in Excel 365](https://geekexcel.com/how-to-change-case-of-text-to-all-caps-lower-and-proper-in-excel-365/)