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

Get FREE Advanced Excel Exercises with Solutions!

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

Here, 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. ### 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:

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

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

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems. 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 Advanced Excel Exercises with Solutions PDF  