While you are working with Excel, you will have to copy formulas frequently from one cell to another cell. Here is how you will do this:
- Select cell B4 and enter this formula “=RAND()”.
Randomizing the rows in Excel. Entering formula in cell B4.
- Press Enter and a random number will be displayed in cell B4. The number is less than 1. Select cell B4 again. You will see the Fill Handle square box.
Randomizing the rows in Excel. A random number(<1) is displayed in cell B4. We have selected cell B4 again.
- To copy this formula to other cells of column B, just click on the Fill Handle, hold your mouse, drag down until you have reached the cell B132 in our example. Or you can use this technique. Click on cell B4. While clicking cell B4, press Shift and use navigation arrow (⇓) to reach cell B132. Cells are selected, now click CTRL+D to auto-fill all cells (you have selected) with the formula in cell B4.
Randomizing the rows in Excel. Cells are filled with random numbers.
Happy Excelling 🙂