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

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

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

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