To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. Sometimes it might seem difficult to copy formula down with shortcut. In terms of copying formulas in Microsoft Excel, there are lots of ways to use keyboard shortcuts. In this article, I am going to show you some ways with shortcut to copy formula down in Excel.
Below, I have shared 6 simple methods to copy formula down with shortcut in Excel.
How to Copy Formula Down with Shortcut in Excel: 6 Creative Ways
Suppose we have a dataset of some Product Names, Prices, and Discount offers for those Products. Here we have also calculated the Discount Price for cell D5. Now we will learn to copy the formula down shortcut in the workbook.
1. Using Keyboard Shortcut to Copy Formula Down for a Column in Excel
Using the keyboard shortcut you can easily copy a formula down in Excel. When you are copying a formula down within a single column start with the following steps.
Steps:
- First, choose a cell (D7) and press CTRL+SHIFT+END to select all the cells in the column.
- Then, press CTRL+D from the keyboard.
- As you can see we have successfully copied the formula down in the column.
Read More: How to Copy Exact Formula in Excel
2. Using SHIFT Key Sequence As Shortcut to Copy Formula Down
Another short technique to copy a formula down is you have to press some keys sequentially to reach your desired point.
Steps:
- Similarly, choose a cell (D7) with the formula and press the SHIFT+Down arrow key (↓) repeatedly to select all the cells you want to fill with.
- Hence, holding the ALT button click H+F+I from the keyboard.
- In summary, we have successfully copied the formula for the chosen cells without any hesitation. Simple isn’t it?
Read More: How to Copy SUM Formula in Excel
3. Applying CTRL+’ Keys to Copy the Exact Formula Down in Excel
Sometimes you might feel the need to copy the exact formula in every cell of a column or row. In that situation, you can follow the below instructions-
Steps:
- Select a cell (E8) just below the cell (E7) with the formula in it.
- Hence, press- CTRL+’.
- Immediately, the formula will be displayed in the selected cell.
- Now, press ENTER.
- To finish, follow the same task again and again until you fill cells with the exact formula.
- Within a moment, we completely copied the formula down in Excel using a simple shortcut.
Read More: Creating and Copying Formula Using Relative References in Excel
4. Copying Formula Down in Excel Using CTRL+C and CTRL+V Shortcuts
If you want you can use the copy and paste shortcut to copy the formula down in your worksheet.
Steps:
- Presently, select a cell (D7) that has the precious formula that you want to copy for the other cells.
- While selecting the cell (D7) press CTRL+C to copy.
- Therefore, choose the immediate cell (D8) below and click CTRL+V to paste.
- Thus, you will get the formula copied to the below cell.
- Now, do the task repeatedly for the other cells following the same task.
- In conclusion, we have copied the formula down within seconds.
Read More: How to Copy a Formula across Multiple Rows in Excel
5. Using Excel VBA Code to Copy Formula Down
In order to copy formulas down in Excel easily, you can use VBA code. Here I will show you how to copy formula for columns using a simple VBA code. Follow the instructions below-
Steps:
- First, select cells (D7:D13) and click ALT+F11 to open the “Microsoft Visual Basic for Applications” window.
- From the new window open a new “Module” from the “Insert” option.
- In the new module, type the following code and click “Save”-
Sub Copyformula_Column()
Selection.AutoFill Destination:=Range(Selection, Cells(ActiveCell.SpecialCells(xlLastCell).Row, Selection.Column))
End Sub
- Next, select “Macros” from the “Developer” option.
- A new dialog box will appear named “Macro”.
- Hence, select the “Macro Name” from the dialog box and press “Options” to continue.
- This time choose your desired shortcut key and click OK.
- Now, returning to the worksheet, press CTRL+E from the keyboard as we have chosen “CTRL+E” as our shortcut key in the previous window.
- Finally, the column is filled with a formula copied in Excel.
Read More: How to Copy Formula to Entire Column in Excel
Shortcuts to Copy Formula Through Rows
1. Applying Keyboard Shortcut to Copy Formula for a Row
To copy the formula down with a shortcut for rows you just have to press the CTRL+R key. Follow the steps below-
Steps:
- To start with, select range C8:I8 and click the CTRL+R button from the keyboard.
- Finally, the formula is copied row-wise for all the selected cells.
2. VBA Code to Copy Formula Down with Shortcut
If you want to employ a shortcut to copy the formula down for rows then you can follow the same technique but with a different VBA code.
Steps:
- Similarly, selecting range C8:I8 press ALT+F11 to open the “Microsoft Visual Basic for Applications”.
- In the same fashion, open a new module and write the below code down-
Sub Copyformula_Row()
Selection.AutoFill Destination:=Range(Selection, Cells(Selection.Row, ActiveCell.Offset(-1, 0).End(xlToRight).Column))
End Sub
- Just like the previous sub-method, create a shortcut key for the macro and then in the worksheet click the shortcut to get your precious output.
- In conclusion, we have successfully copied the formula down in Excel with a simple shortcut.
Dragging Mouse Button to Copy Formula Down: Excel Fill Handle
Instead of using the keyboard, you can try the mouse’s left button to drag and fill cells to copy the formula down quickly.
Steps:
- Here, choose a cell (D7) with a formula in it and then move the mouse cursor over the border of the cell.
- Thus, you will get to see a “Fill Handle” icon just like the following screenshot.
- Simply, pull the “Fill Handle” down to fill the cells with the formula.
- Within a glimpse of your eye, the column will be filled with the formula copying the formula. Isn’t it a simple trick?
Things to Remember
Using the “Fill Handle” tool you can also copy the exact same formula in the same row or column. For that, after filling choose the icon at the end cell, and from there press “Copy Cells” to copy the exact formula.
Download Practice Workbook
Conclusion
In this article, I have tried to cover all the methods to copy formula down with shortcut in Excel. Take a tour of the practice workbook and download the file to practice by yourself. I hope you find it helpful. Please inform us in the comment section about your experience. Stay tuned and keep learning.
Related Articles
- How to Copy a Formula in Excel with Changing Cell References
- How to Copy Formula in Excel to Change One Cell Reference Only
- How to Copy a Formula in Excel Without Changing Cell References
<< Go Back to Copy Formula in Excel | Excel Formulas | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
