Shortcut to Copy Formula Down in Excel (7 Ways)

Copy it down up to cell F8

To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. In terms of copying formulas in MS Excel, there are lots of ways to use keyboard shortcuts. In this article, I am going to show you some ways of shortcuts at the time of copying down any formula in excel.

Download the Practice Workbook

7 Shortcuts to Copy Formula Down in Excel

1. Ctrl + D for Copying the Formula Across a Column

We have a dataset like the following image. We want to calculate the price of the fruits after the discount. In cell C4, I have used formula =B4*(1-$B$1) to calculate the price of each fruit after giving a discount. We want to copy down this formula up to cell C7. Follow the steps below.

Ctrl + D for Copying the Formula Across a Column

Step 1: Select the cells from C4 to C7. (Shortcut CTRL + SHIFT + END)

Select the cells from C4 to C7. (Shortcut CTRL + SHIFT + END)

Step 2: Press CTRL + D on your keyboard. You will find that the formula in cell C4 is copied from cell C5 to C7

 Press CTRL + D on your keyboard. You will find that the formula in cell C4 is copied from cell C5 to C7

2. CTRL + R for Copying Formula Across a Row

Now we want to show the same method for copying any formula across a row. We have the following data. We want to copy down this formula from B4 to E4.

CTRL + R for Copying Formula Across a Row

Step 1: Select the cells from B4 to E4

 Select the cells from B4 to E4.

Step 2: Press CTRL + R on your keyboard. You will find that the formula in cell B4 is copied from cell B4 to E4

Press CTRL + R on your keyboard. You will find that the formula in cell B4 is copied from cell B4 to E4

Here the formula is directly copied from the cell reference from the previous cell. That is why there is a need for editing before entering.

3. Copy Down Formulas with a Single Mouse Interaction

This is one of the easiest ways to copy down any formula in excel with just one-time mouse interaction. That means you will need to use the keyboard only once after that you can do the job easily with the keyboard. This shortcut is also shown with the same example above.

Step-1: Enter the desired formula into any cell and press enter

Enter the desired formula into any cell and press enter

Step-2: Select the last cell of the range

Select the last cell of the range

Step-3: Enter Ctrl+Y and all the values will be calculated within the range

Enter Ctrl+Y and all the values will be calculated within the range

That’s it.

4. Using Key Sequence for Fill Series

Another shortcut for copying down formulas is the Key Sequence for Fill Series. This is a little bit lengthy but more useful.

Step-1: Enter the formula in the first cell

Enter the formula in the first cell.

Step-2: Select the other cells along with the first cell using Shift + Down Arrow

Select the other cells along with the first cell using Shift + Down Arrow

Step-3: Press the following things sequentially.

ALT >> H >> F >> I

Then this box will pop up

 Press the following things sequentially.

Step-4: Press Enter and all the values will be shown

 Press Enter and all the values will be shown.

Thus, the one way to copy down formula one by with the shortcuts key.

5. Copy a Formula into Multiple Cells by Dragging/ Clicking and Dragging the Mouse

Now in this section, we will copy the same formula above using mouse hovering. Again, here the dataset will be the same.

 CTRL + ENTER to copy a formula into multiple cells

Step 1: First enter the formula in cell F4

=C4*(1-$F$3)

Enter the formula

Step 2: Now click on the corner of the formula cell

click on the cell corner

Step 3: Then hover the mouse up to the last cell (F8)

Copy it down up to cell F8

6. CTRL +’ for Copying the Exact Formula Down in Excel

Sometimes we may need to copy down the same formula in Excel. For this purpose, Excel also provides another shortcut key which is CTRL + ‘(Single quotation). Let’s consider we have one formula which is in cell F4. Now we will make a copy of this formula (exact) in the below cell.

Step 1: First go to cell F5

 First go to cell F5

Step 2: Now press CTRL + ‘

Now press CTRL + ‘

Step 3: Then press Enter

 Then press Enter

Step 4: This way you can make multiple copies of this formula

 This way you can make multiple copies of this formula

7. CTRL + C and CTRL + V to copy formula down in Excel

We have saved the easiest for the last example. we will see the most popular method to copy any formula using CTRL + C and CTRL + V using the same dataset.

Step 1: First enter the formula in the first cell

CTRL + C and CTRL + V to copy formula down in Excel

Step 2: Now press CTRL + C and go to the second cell below

 Ctrl + c

Step 3: Then press CTRL + V and do it for the rest of the cells

 Copy formula down

Conclusion

These are some shortcuts to Copy Formula Down in Excel. I have shown all the methods with their respective examples but there can be many other iterations. I have also discussed the fundamentals of the used functions. If you have any other method of achieving this, then please feel free to share it with us.


Further Readings

Md. Abdullah Al Murad

Hello! Welcome to my Profile. Currently, I am working and researching Microsoft Excel, and here I will be posting articles related to this. My last educational degree is BSc, and my program was Computer Science and Engineering from American International University-Bangladesh. I am a Computer Science graduate with a great interest in research and development. Always try to gather knowledge from various sources and try to make innovative solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo