How to copy formula in Excel

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()”.
Data clean-up techniques in Excel: Randomizing the rows

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.
Data clean-up techniques in Excel: Randomizing the rows

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.
Data clean-up techniques in Excel: Randomizing the rows

Randomizing the rows in Excel. Cells are filled with random numbers.

Happy Excelling 🙂


Hello! Welcome to my Excel blog! It took me some time to be a fan of Excel. But now I am a die-hard fan of MS Excel. I learn new ways of doing things with Excel and share here. Not only how to guide on Excel, but you will get also topics on Finance, Statistics, Data Analysis, and BI. Stay tuned!

We will be happy to hear your thoughts

      Leave a reply