How to Generate Random Numbers in Google Sheets

The fastest way to fill a column with random numbers

Google Sheets has a built-in function called RAND() that creates a random decimal number between 0 and 1 each time you use it. To fill a column with random numbers, click the cell where you want to start, type =RAND(), and press Enter. Then copy that cell down as many rows as you need.

If you want whole numbers instead of decimals — say, random numbers between 1 and 100 — use =RANDBETWEEN(1,100) instead. The formula works the same way: type it once, press Enter, then copy it down to fill your list.

Both functions recalculate every time the sheet updates, which means your random numbers will change whenever you edit any cell. If you need the numbers to stay fixed, you'll need to convert them to static values after generating them.

Key Takeaways

Use =RAND() to generate random decimals between 0 and 1, or =RANDBETWEEN(1,100) for whole numbers in a specific range.
Copy the formula down to fill multiple rows — Google Sheets will generate a different random number in each cell.
Random numbers recalculate whenever the sheet changes, so convert them to fixed values if you need them to stay the same.
You can combine RANDBETWEEN with other functions to create lists of random dates, random selections from a list, or random text.

Copying the formula down to create your full list

After you type your formula in the first cell, you need to copy it down to every row where you want a random number. Click the cell with your formula, then look for the small square in the bottom right corner of the cell — this is called the fill handle. Click and drag that square down to the last row you need, and Google Sheets will copy the formula to each cell.

If you have a lot of rows, dragging can be slow. Instead, click the cell with your formula, then hold Shift and click the last cell in the range you want to fill. Now press Ctrl+D (or Cmd+D on Mac), and Google Sheets will fill every cell in between with the formula.

Each cell will show a different random number because the formula recalculates for each row. If you want to see the numbers change in real time, just press F9 or Ctrl+Shift+F9 to force a recalculation.

Keeping your random numbers from changing

The problem with RAND() and RANDBETWEEN() is that they recalculate constantly. If you open the sheet tomorrow, the numbers will be different. If you need the numbers to stay the same, you have to convert them from formulas to values.

Select the cells with your random numbers, copy them (Ctrl+C or Cmd+C), then right-click and choose "Paste special" → "Values only". This replaces the formulas with the actual numbers they showed at that moment. Now they won't change anymore.

You can also use the keyboard shortcut: select the cells, copy them, then press Ctrl+Shift+V (or Cmd+Shift+V on Mac) to open the Paste Special menu directly.

Creating random numbers in a specific range

RANDBETWEEN lets you set the lowest and highest number you want. The formula is =RANDBETWEEN(lowest, highest). For example, =RANDBETWEEN(1,50) gives you a random whole number from 1 to 50. =RANDBETWEEN(100,999) gives you a random three-digit number.

If you need decimals in a specific range, multiply RAND() by the size of your range and add the starting number. For example, =RAND()*100 gives you a random decimal from 0 to 100. To get a random decimal from 10 to 20, use =RAND()*10+10.

You can also nest RANDBETWEEN inside other functions. For instance, =CHOOSE(RANDBETWEEN(1,3),"Red","Blue","Green") picks a random color from your list each time it recalculates.

Using random numbers to shuffle or sample data

If you have a list of names or items and want to put them in random order, add a helper column with =RAND() next to each item. Then select both columns, go to Data → Sort range, and sort by the random number column. Delete the random numbers afterward, and your original list is now shuffled.

To pick a random sample from a larger list, use the same method but only keep the top N rows after sorting. Or use =INDEX() with RANDBETWEEN() to pull random items directly: =INDEX(A:A, RANDBETWEEN(1, COUNTA(A:A))) will pick a random cell from column A.

These techniques are useful for creating random test data, assigning people to groups, or drawing random entries from a pool without bias.

Common mistakes and how to avoid them

The most common mistake is forgetting that RAND() and RANDBETWEEN() recalculate constantly. You generate a list of random numbers, close the sheet, come back later, and they're all different. The fix is to convert to values as soon as you're done generating them.

Another mistake is using RANDBETWEEN with decimals — the function only works with whole numbers. If you need random decimals in a range, use the RAND() multiplication method instead.

If your random numbers all look the same or seem to follow a pattern, that's usually just coincidence — random data often looks clumpy to human eyes. If you genuinely suspect a problem, generate a much larger sample and look at the distribution.

Frequently Asked Questions

Can I generate random numbers without them changing every time I edit the sheet?

Yes. After generating your random numbers with a formula, select them, copy, then right-click and choose "Paste special" → "Values only". This converts the formulas to fixed numbers that won't recalculate.

How do I create a random list of numbers between two specific values?

Use =RANDBETWEEN(lowest, highest) for whole numbers. For example, =RANDBETWEEN(50,150) gives a random number from 50 to 150. For decimals, use =RAND()*(highest-lowest)+lowest, so =RAND()*50+50 gives a random decimal from 50 to 100.

What's the difference between RAND() and RANDBETWEEN()?

RAND() generates a decimal between 0 and 1. RANDBETWEEN() generates a whole number between two values you specify. Use RAND() when you need decimals or want to multiply the result; use RANDBETWEEN() when you need whole numbers in a specific range.

Can I use random numbers to shuffle a list of names?

Yes. Add =RAND() in a helper column next to your names, then select both columns and go to Data → Sort range. Sort by the random column, then delete it. Your names are now in random order.

Why do my random numbers keep changing?

RAND() and RANDBETWEEN() recalculate whenever the sheet updates — even when you edit a different cell. This is normal behavior. If you need numbers that stay the same, convert them to values using Paste Special → Values only.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.