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.

**Table of Contents**hide

## 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.

**Step 1:** 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**

**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**.

**Step 1:** 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**

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

**Step-2:** Select the last cell of the range

**Step-3:** 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

**Step-2: **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

**Step-4:** 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.

**Step 1:** First enter the formula in cell **F4**

`=C4*(1-$F$3)`

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

**Step 3**: Then hover the mouse up to the last 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**

**Step 2: **Now press **CTRL + ‘**

**Step 3: **Then press **Enter**

**Step 4: **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

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

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

**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.