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