How to Drag Formula in Excel with Keyboard (7 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

Download Workbook


7 Methods to Drag Formula in Excel with Keyboard

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 formula in Excel with keyboard . Here, we used Excel 365. You can use any available Excel version.

How to Drag Formulas in Excel with Keyboard


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+D5

Here, this formula simply adds cell C5 with cell D5.

  • After that, press ENTER.

How to Drag Formulas in Excel with Keyboard

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.

How to Drag Formulas in Excel with Keyboard

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 (With Quick Steps)


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

How to Drag Formulas in Excel with Keyboard

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

How to Drag Formulas in Excel with Keyboard

Finally, we can see the result of the Drag Formula in Excel with Keyboard.

Read More: [Fixed!] Excel Drag to Fill Not Working (8 Possible Solutions)


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.

How to Drag Formulas in Excel with Keyboard

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

How to Drag Formulas in Excel with Keyboard

Read More: How to Drag Formula and Ignore Hidden Cells in Excel (2 Examples)


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:

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

How to Drag Formulas in Excel with Keyboard

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

How to Drag Formulas in Excel with Keyboard

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


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+D5

Here, this formula simply adds cell C5 with cell D5.

  • After that, press ENTER.

How to Drag Formulas in Excel with Keyboard

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

How to Drag Formulas in Excel with Keyboard


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.

How to Drag Formulas in Excel with Keyboard

Read More: How to Use Fill Handle to Copy Formula in Excel (2 Useful Examples)


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.

How to Drag Formulas in Excel with Keyboard

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

How to Drag Formulas in Excel with Keyboard

Read More: Drag Number Increase Not Working in Excel (A Solution with Easy Steps)


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. Please visit our website Exceldemy to explore more.


Related Articles

Afia Kona

Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo