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.

**Table of Contents**hide

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

### 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 (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**.

- 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: ****[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**.

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

**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:**

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

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

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

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

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

**[Fixed!] Excel VLOOKUP Drag Down Not Working (11 Possible Solutions)****Fill Down to Next Value in Excel (5 Easy Methods)****How to Fill Down to Last Row with Data in Excel (3 Quick Methods)****[Solved]: Fill Handle Not Working in Excel (5 Simple Solutions)****How to Fill Formula Down to Specific Row in Excel (7 Easy Methods)****How to Use Fill Handle in Excel (4 Quick Tricks)**