How to Insert a Random Number in Excel

Date：2019-8-6

Random numbers are quite useful in many situations of life and work. And it’s very simple to generate them with Excel function. Here’s the method.

1. Open the Excel file, click a cell and type the formula in it. If you want to generate a number in the range of 1-100, then input “=RANDBETWEEN(1,100)” .

2. Press Enter (or click anywhere outside the cell). You’ll get a random number immediately.

3. Put the cursor at the bottom right corner of the cell till it become a small black cross. Drag it to select all the cells you want to insert random numbers, then release the mouse.

4. Now the randbetween function is applied to all these selected cells.

5. If you want to generate random decimals, you should use rand function. Input “=RAND()” in the cell and press Enter.

6. With fill handle, you can apply this formula to multiple cells as well.

7. If the result is either “0” or “1”, the reason must be the setting of the cell format. Select the cells you want to insert random decimals and press [Ctrl+1] (or right click selected cells and choose Format Cells… in the menu).

8. You can choose Number in the Category of Number tab in the popping out window and check the setting of Decimal places. It can’t be “0” or else the decimals can’t be displayed. Here I typed “5” and hit OK to confirm it.

9. Then the random decimals will display according to your setting.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.