While you are working with Excel, you will have to copy formula frequently from one cell to other cells. Here is how you will do this:
- Select cell B4 and enter this formula “=RAND()”.
- 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.
- 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.
Happy Excelling 🙂