Excel random number generator from list

Creating a random number generator in Excel is super easy and can be done in just a few steps. By using Excel’s built-in functions, you can generate random numbers for various applications, such as simulations, statistical sampling, or even games.

Let’s break down the process so you can get started quickly.

How to Do a Random Number Generator in Excel

By the end of the following steps, you’ll have a simple random number generator set up in Excel, ready to churn out those unpredictable digits whenever you need them.

Step 1: Open Excel

Open your Excel application.

Starting with a new or existing workbook ensures you have a place to generate and store your random numbers.

Step 2: Select a Cell

Click on any cell where you want to display the random number.

Choosing a cell gives you a specific location for your random number, making it easy to reference later.

Step 3: Enter the Formula

Type or into the cell and press Enter.

The function generates a decimal number between 0 and 1, while allows you to specify a range for whole numbers.

Step 4: Drag the Fill Handle

Clic

how to generate random numbers in excel from a list

how to generate random numbers in excel with mean and standard deviation