# Shortcut to Copy Formula Down in Excel (7 Ways) 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.

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