Sometimes we need to copy formula in **Excel** without dragging. In this article, we will show you how to copy formula in **Excel** without dragging with 9 easy approaches. We have also included some relevant concerns at the end of this article. So, let’s get started.

## 📂 Download Excel File

Download free workbook from here:

## Learn to Copy Formula in Excel Without Dragging with These 9 Approaches

While writing this article, “How to Copy Formula in **Excel** without Dragging”, we’ve considered a dataset that contains approximately 5 columns and 14 rows. In this dataset, we added **Name**, **Income**, **Expenditure**, and **Savings** to make you better understand. But if you want, you can change the entities and put your own values.

**APPROACH**

### 1. Double-Clicking Fill Handle Icon

You can **Double**–**Click **on your mouse to copy the formula in **Excel** without dragging. It is a very easy step. You can do this easily. Follow the given steps.

⬇️⬇️ **STEPS **⬇️⬇️

- Initially, select cell
**E6**. - Secondly, write the following formula on that cell.

**=C6-D6**

- Now press
**Enter**. - Then place the
**fill handle**just like the below picture and**Double-Click**on that.

- Finally, you will see the result as well.

Undoubtedly, this is a very easy way to copy formula in **Excel** without dragging.

**📕 Read More: ****3 Ways to Copy Formula with Relative Reference Using Excel VBA**

**APPROACH**

### 2. Pressing Ctrl+Enter

To copy the formula in **Excel** without dragging, you can also tap **Ctrl**+**Enter**. It is very simple. You just need to maintain the following steps.

⬇️⬇️ **STEPS **⬇️⬇️

- First, you need to select the entire
**E** - Secondly, write the following formula on cell
**E6**.

**=C6-D6**

- Thirdly, press
**Ctrl**+**Enter**. - Consequently, you will get the result you need.

Truly, you can achieve this technique easily.

**📕 Read More: ****How to Copy Formula Down in Excel Without Incrementing**

**APPROACH**

### 3. Using Keyboard Shortcuts

If you want, you can use the keyboard shortcuts to copy formulas in **Excel** without dragging. You just follow the below steps to achieve this approach.

⬇️⬇️ **STEPS **⬇️⬇️

- Primarily, you need to select cell
**E6**. - Secondly, write the following formula on that cell.

**=C6-D6**

- Now press
**Enter**. - Thirdly, press
**Ctrl**+**C**to copy cell**E6**.

- Then press
**Ctrl**+**Left**(⬅️) key to go to the left cell. - Afterward, press
**Ctrl**+**Down**(⬇️) key to go to the last cell. - After that press
**Ctrl**+**Right**(➡️) key to go to the right cell. - Sixthly, tap
**Ctrl**+**Shift**+**Up**(⬆️) key to select the entire**E**column.

- Finally, press
**Ctrl**+**V**. - Eventually, the result will appear to you.

Indeed, this is a very easy and handy way to work.

**📕 Read More: ****4 Quick Ways to Copy Formula Down with Shortcut in Excel**

**APPROACH**

### 4. Using Name Box

You can use **Name Box **to copy formula in **Excel** without dragging. Follow the below procedures.

⬇️⬇️ **STEPS **⬇️⬇️

- Firstly, you need to select cell
**E6**. - Secondly, write the following formula on that cell.

**=C6-D6**

- Now press
**Enter**. - Thirdly, press
**Ctrl**+**C**to copy cell**E6**. - Fourthly, write the below range to the
**Name Box**.

**E6:E14**

- Again press
**Enter**. - You will see the entire
**E**column selected.

- Afterward, tap
**Ctrl**+**V**. - Consequently, you will find the desired result.

Finally, you must say that this is a simple step to copy formula in **Excel** without dragging.

**📕 Read More: ****6 Ways to Copy a Formula Across Multiple Rows in Excel**

**APPROACH**

### 5. Applying Fill Down Feature

Applying the **Fill **feature to copy formula in **Excel** without dragging is a lot easier than you think. You just need to maintain the following steps as well.

⬇️⬇️ **STEPS **⬇️⬇️

- Initially, you need to select cell
**E6**. - Secondly, write the following formula on that cell.

**=C6-D6**

- Now press
**Enter**. - Thirdly, select the whole
**E**column. - Then go to the
**Home**tab. - Fourthly, select the
**Editing**option and then click on**Fill Down**.

- Finally, your desired result will appear to you.

Indeed this step is one of the simplest procedures.

**📕 Read More: ****Copy Formula and Change Only One Cell Reference in Excel**

**APPROACH**

### 6. Adopting Table Feature

If you want to copy formula in **Excel** without dragging then you can adopt the **Table **feature as well. You can do this easily if you follow the given steps.

⬇️⬇️ **STEPS **⬇️⬇️

- Primarily, go to the
**Insert**tab. - Then select the
**Table**option.

- After that, you will get a dialogue box name
**Create Table**containing the range. - Then you need to press
**OK**.

- Afterward, select cell
**E6**and write the following formula there.

**=[@Income]-[@Expenditure] **

- Finally, tap
**Enter**.

- Eventually, you will see the result as well.

Hardly you can find an easier technique than this one.

**APPROACH**

### 7. Applying Power Query Method

The** Power Query** method is one of the unique features of **Excel**. You can copy formula without dragging using the **Power Query Editor**. For this, you need to maintain the following steps.

⬇️⬇️ **STEPS **⬇️⬇️

- First, go to the
**Data**tab on the worksheet. - Secondly, choose the
**From Table/Range**.

- Then you will see a dialogue box name
**Create Table** - Thirdly, select the range:

**$B$5:$D$14**

- Check the
**My table has headers**. - Fourthly, click on
**OK**.

–

- After that, you will get the
**Power Query Editor**. - Belatedly, select
**Add Column**and then click on the**Custom Column**.

- Again you will get a window name
**Custom Column**. - Write “
**Savings**” on the**New column name**. - Sixthly, write the following formula on the
**Custom column formula**:

**=[Income]-[Expenditure]**

- Then click on
**OK**.

- Seventhly, go to the
**Home**tab and select**Close & Load**.

- Finally, you will get the result with the help of
**Power Query Editor**.

Indeed, this approach is very simple for you.

**APPROACH**

### 8. Using Dynamic Array

Using a dynamic array is one of the easiest approaches to copying formula down without dragging in **Excel**. You just need to follow the instructions given below.

⬇️⬇️ **STEPS **⬇️⬇️

- Initially, select cell
**E6**. - Secondly, write the given formula on that cell.

**=(C6:C14)-(D6:D14)**

- Thirdly, press
**Enter**.

- Eventually, you will find your required result as well.

Undoubtedly, this one is very helpful for you.

**APPROACH**

### 9. Creating VBA Macro

Using **VBA **code is one of the best ways to copy formula down without dragging in **Excel**. It is a very simple and handy approach. You have to maintain the following steps.

⬇️⬇️ **STEPS **⬇️⬇️

- First, go to the worksheet.
- Secondly, press
**Alt**+**F11**. - A
**VBA**window will appear to you. - Thirdly, insert a
**Module**.

- Fourthly, paste the following code on that module.

**Code**

```
Sub FormulaWithoutDrag()
Dim Lr1 As Long
Dim r As Long
Lr1 = Cells(Rows.Count, "C").End(xlUp).Row
For r = 6 To Lr1
Cells(r, "E").Value = Cells(r, "C").Value - Cells(r, "D").Value
Next r
End Sub
```

- Now tap
**Run**.

- Eventually, you will get the result you wanted to have.

Undoubtedly, this is a very effortless way to work on.

**📕 Read More: ****9 Examples to Copy Formula from Above Cell Using VBA in Excel**

## How to Copy Formula in Excel to Another Sheet

If you want to** copy formula to another sheet in Excel **then this portion is for you. You can do this easily if you follow the given steps properly.

⬇️⬇️ **STEPS **⬇️⬇️

- Firstly, you need to select cell
**E6**. - Secondly, write the following formula on that cell.

**=C6-D6**

- Now press
**Enter**. - Thirdly, press
**Ctrl**+**C**to copy cell**E6**.

- Fourthly, go to another worksheet in
**Excel**. - Then select cell
**E6**of that sheet and tap**Ctrl**+**V**.

- Consequently, you will find that your formula has been copied to another sheet.

Truly, this procedure is simple enough to copy formula to another sheet in **Excel**.

## How to Copy Formula in Excel Without Changing References

You can also** copy formula without changing references** in **Excel**. It is also very easy to achieve. Follow the given instructions.

⬇️⬇️ **STEPS **⬇️⬇️

- Primarily, you need to select cell
**E6**. - Secondly, write the following formula on that cell.

**=C6-D6**

- Now press
**Enter**. - Thirdly, go to the formula bar, select the formula, and press
**Ctrl**+**C**to copy the formula as well.

- Fourthly, select another cell and press
**Ctrl**+**V**. - Eventually, you will see that your formula has been copied to that cell without changing references.

Undoubtedly, this approach is very handy to work.

## 📄 Important Notes

You should be aware of the following things while performing the processes mentioned above:

🖊️ You need to be careful while selecting the range for the dynamic array.

🖊️ You have to be conscious when you intend to use the **Power Query Editor**.

## 📝 Takeaways from This Article

If we summarize the whole article, we have got some points.

📌 Primarily, we used the double-clicking method to copy formula in **Excel** without dragging.

📌 Secondly, we used the **Ctrl**+**Enter **keys.

📌 Thirdly, we used the **Name Box **in **Excel**.

📌 Fourthly, we applied the **Fill **feature in **Excel**.

📌 Fifthly, we adopted the **table **feature.

📌 Sixthly, we applied the **Power Query **method.

📌 Seventhly, we used a dynamic array,

📌 Afterward, we applied **VBA **code to copy formula without dragging.

📌 Belatedly, we copied formula to another sheet in **Excel**.

📌 Finally, we copied formula without changing references in **Excel**.

## Conclusion

We wish that you would be able to copy formula in **Excel** without dragging using this article. As several methods have been shown here, you can easily follow which one is best suited for you. If you have any skepticism, feel free to ask me in the comment. In the end, to learn more about **Excel** tactics, we recommend you to visit our website **www.ExcelDen.com**.