# How to Generate Random Spreadsheet Data in Microsoft Excel [ Full Tutorial ]

## Description:

In this tutorial, we will discuss How to generate random data in Microsoft Excel. When we apply or perform different operations and tools of Microsoft Excel program, a big dummy or sample data is required to execute these operations. Two function use for generates random values in Microsoft Excel. How to generate random spreadsheet data in Microsoft Excel.

How to Generate Random Spreadsheet Data in Microsoft Excel

### Version: 2007 To 2013

1. RAND() Function.
2. RANDBETWEEN() Function

## How to Generate Random Spreadsheet Data in Microsoft Excel

Let’s start working, how to generate random spreadsheet data in Microsoft Excel.

## Function No. 01 : RAND() Function.

RANd Function returns an evenly distributed random real number greater than or equal to 0 and less than 1. A new random real number is returned every time the worksheet is calculated.

## Syntax:

=rand()    A random number between 0 and 1 (varies) .

Example 01:

Type rand() function in the cell where you want to enter random data.

=rand() (Enter)

## ScreenShot: Example 02:

=rand()*100 (Enter) How to Generate Random Spreadsheet Data in Microsoft Excel In Easy Way

Note:  If you want to increase/decrease decimal in value then you can use number tools in home ribbon. 