Excel Guides

AutoFill with Random Numbers in Excel

If you're looking to autofill a column in Excel with random numbers, there are a few different ways you can go about it.

One option is to use the RAND function. This function will generate a random number between 0 and 1. So, if you wanted to generate a random number between 1 and 100, you would use the following formula:

=RAND()*100+1

Another option is to use the RANDBETWEEN function. This function allows you to specify a range of numbers that you want the random number to be between. So, using the same example as above, you would use the following formula:

=RANDBETWEEN(1,100)

Once you have your formula entered into the first cell of the column that you want to fill, simply press Enter and then drag the fill handle (the small square in the bottom-right corner of the cell) down to however many cells you want to fill.

And that's all there is to it! Whether you use the RAND or RANDBETWEEN function, filling a column with random numbers in Excel is a quick and easy task.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.