If you want to drag formula in Excel with keyboard , this article is for you. Here, we will demonstrate to you 7 easy, and effective methods to do the task effortlessly.
How to Drag Formula in Excel with Keyboard: 7 Methods
The following dataset table has ‘Name’, ‘Salary’, ‘Increment’, and ‘Total Salary’ columns. We will use a formula to calculate the ‘Total Salary’ in cell E5, and we will show 7 methods that will help you to drag the formula in Excel with keyboard. Here, we used Excel 365. You can use any available Excel version.
Method-1: Using Copy Paste Shortcuts to Drag Formula in Excel with Keyboard
In this method, we will use the keyboard shortcut CTRL + C to copy the formula and CTRL + V to drag the formula.
Steps:
- First, we will type the following formula in cell E5.
=C5+D5Here, this formula simply adds cell C5 with cell D5.
- After that, press ENTER.
We can see the result in cell E5.
- Next, we will select cell E5 > then press CTRL + C.
- After that, we will select cell E6 by using SHIFT + Down Arrow then type CTRL + V.
We can see the result in cell E6.
- Afterwards, we will type CTRL + V in the rest of the cells of the ‘Total Salary’ column.
Finally, we can see the result of the drag formula in Excel with keyboard.
Read More: How to Enable Drag Formula in Excel
Method-2: Use of CTRL+C , F5, and CTRL+V Keys to Drag Formula in Excel with Keyboard
Here, we will type CTRL + C to copy a formula, after that, we will press the F5 key to bring out the Go To window and we will type CTRL + V to drag formula with keyboard.
Steps:
- First, we will type the following formula in cell E5 to add up cells C5 and D5.
=C5+D5
- After that, press ENTER.
- Then, we will select cell E5 and type CTRL + C to copy the cell.
- Afterwards, we will press the F5 key.
A Go To dialog box will appear.
- In the Reference box, we will type E12, as we want to drag the formula to cell E12.
- After that, press SHIFT +Â ENTER, this will select the cells from E5 to E12.
- Then, press CTRL + V.
Finally, we can see the result of the drag formula in Excel with keyboard.
Read More:Â How to Drag Cells in Excel Using Keyboard
Method-3: Using SHIFT+Down Arrow & CTRL+D to Drag Formula Down
Here, we will use the SHIFT + Down Arrow key to select cells in a column, after that, we will press CTRL + D to drag down the formula.
Steps:
- First, we will type the following formula in cell E5 to add up cells C5 and D5.
=C5+D5- After that, press ENTER.
- Then, select cell E5 and type SHIFT + Down Arrow key.
We can see the selected cells from E5 to E12.
- Then, press CTRL + D.
Finally, we can see the result of the drag formula in Excel with keyboard.
Method-4: Inserting CTRL+R Keys to Drag Formula Towards Right
Here, we will use the CTRLÂ +Â R keys to drag the formula toward the right.
Steps:
- First, we will type the following formula with the SUM function in cell C13.
=SUM(C5:C12)Here, the SUM function adds up the cells from C5 to C12.
- After that, press ENTER.
We can see the result in cell C13, and we want to drag the formula of cell C13 to the right.
- Afterwards, we will select cell C13.
- Then, select cell D13 and type CTRL + R.
We can see the result in cell D13.
- Similarly, we will select cell E13 and press CTRL + R.
Finally, we can see the result of the drag formula in Excel with keyboard.
Method-5: Applying CTRL+ENTER Keys to Drag Formula in Excel with Keyboard
In this method, we will use the CTRL + ENTER keys to drag formula downwards in a column.
Steps:
- First, we will type the following formula in cell E5.
=C5+D5Here, this formula simply adds cell C5 with cell D5.
- After that, press ENTER.
- Then, select cell E5 and type SHIFT + Down Arrow key.
- Then, we will press the F2 key to go to the first selected cell E5.
- After that, we will type CTRL + ENTER keys.
Finally, we can see the result of the drag formula in Excel with keyboard.
Read More: How to Drag Formula and Ignore Hidden Cells in Excel
Method-6: Use of Table Feature to Drag Formula in Excel
Here, we will insert a table and we will show how to drag formulas in a column of the table.
Steps:
- First, we will select the entire dataset > go to the Insert tab > select Table.
A Create Table dialog box will appear. Make sure My table has header box is marked.
- Click OK.
- After that, we will type the following formula in cell E5.
=[@Salary]+[@Increment]Here, this formula adds up the ‘Salary’ column with the ‘Increment’ column.
- Then, press ENTER.
Finally, we can see the result of the drag formula in Excel with keyboard.
Method-7: Using Combination of ALT+H+F+I+S and ALT+F Keys
Here, first we will use the combination of ALT + H + F + I + S keys and then ALT + F keys to drag formula in a column.
Steps:
- First, we will type the following formula in cell E5 to add up cell C5 and D5.
=C5+D5
- After that, press ENTER.
- Then, select cell E5 and type SHIFT + Down Arrow keys.
- After that, we will type ALT + H + F + I + S keys one by one.
A Series of dialog box will appear.
- Afterwards, we will type ALT + F.
- Then, we will press ENTER.
Finally, we can see the result of the drag formula in Excel with keyboard.
Read More: How to Drag Formula Horizontally with Vertical Reference in Excel
Download Workbook
Conclusion
Here, we tried to show you 7 methods to drag formula with keyboard in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section.
