# 9 ways to Copy Formula Down in Excel without Dragging

In normal cases of auto-filling a formula down in a column, we all are comfortable with using the **Fill Handle**. But using the **Fill Handle** can be a time-killing solution if your datasheet has a lot of cells. I’m going to show you 9 ways to copy a formula down in Excel without dragging the **Fill Handle**.

## Introduction to the Dataset

For this article, I am going to use a simple dataset of a list of fast food items (**column A**) from a restaurant, their raw price (**column B**) and their price with 15% VAT (**column C**).In the column **Price (15% VAT)**, I have used an easy formula:

**=B2+B2*15%**

**Formula Explanation**

**B2**is the original price of the food items.**B2*15%**is the 15% increase in food prices.

## Quickest Way to Copy Formula Down in Excel without Dragging

You don’t have to drag the **Fill Handle** always to copy a formula in your datasheet. There is a better way to do it. Follow these two steps.

**Now Follow The Guide ↓ **

**Step_1: **Take the cursor in the right bottom corner of **cell C2** to bring the **Fill Handle ‘+’ icon**.

**Step_2: **Double click on the **Fill Handle**.

**Final Result ↓ **

This way the **Fill Handle** will autofill the rest of the cells of the column with the formula if your column has a single sequence of cells.

I am giving an example below for your convenience.

**Row 6** is blank here in the dataset.

Now if you double click on the **Fill Handle**, the formula will only be applied from **cell C2** to** cell C5**.

You can overcome this problem though. To apply the formula in the entire column, manually drag down the **Fill Handle**.

**🔗 6+ Ways to Copy a Formula in Excel with Changing Cell References**

### Alternative Way #1: Use Excel TABLE

**Excel Table** can help you to copy down a formula in Excel sheets.

But in this case of using** Excel Table**, first, set the table and then put the formula in the **Table**.

**Now Follow The Guide ↓ **

**Step_1: **Select the **Insert** tab.

**Step_2: **Under the **Tables **group, Select the **Table **command.

The **Create** **Table** dialog box will come along on the screen.

**Step_3: **Select your table range.

**Step_4: **Check the **My table has headers** checkbox has a checkmark.

**Step_5: **Hit the **OK **button.

You will notice your data table has a **Table **format now.

**Step_6: **Write your preferable formula in **cell C2**.

**Step_7: **Press **ENTER**.

**Final Result ↓ **

The formula has been set in the rest of the cells now.

I am using the previous example where the data of **row 6** is missing.

Now type the formula in the top cell of **Price (15% VAT) – column C**.

You will see the formula has filled the column, even though the cells are not adjusted.

**🔗 3 Ways to Copy a Formula in Excel without Changing Cell References**

### Alternative Way #2: Use CTRL+C and CTRL+V Keyboard Shortcuts to Copy Formula Down in Excel without Dragging

We all know how to copy and paste something. But copy-paste can also be an alternative method to copy a formula down without dragging the **Fill Handle**.

**Now Follow The Guide ↓ **

**Step_1: **Select the top cell **(cell C2) **with the formula.

**Step_2: **Click on the **Home **tab.

**Step_3: **From the **Clipboard **group, select the **Copy **command (or press **CTRL+C**)**.**

**Step_4: **Now select all the cells of **column C**.

**Step_5: **Again from the **Clipboard **group, click on the **Paste **command (or press **CTRL+V**).

**Final Result ↓ **

This way you can copy and paste a formula through the columns without going for the drag down technique.

**🔗 4 Ways to Fill Formula Down to Specific Row in Excel**

### Alternative Way #3: Use the Fill Command to Copy Formula Down in Excel without Dragging

Another quick way to copy the formula without dragging the **Fill Handle** is to use the **Fill **command.

**Now Follow The Guide ↓ **

**Step_1:** Select the cells of **column C**.

**Step_2: **Select the **Home **tab.

**Step_3: **From the **Editing** group, click on the **Fill **drop-down menu.

**Step_4: **From the** Fill **drop-down list, select the **Down **command.

**Final Result ↓**

You will get the same desired result without dragging the formula.

**🔗 5+ Proven Methods to Copy a Formula to Entire Column in Excel**

### Alternative Way #4: Use the Power Query to Copy Formula Down in Excel without Dragging

You don’t need to add an additional column for the formulas in the sheet. You can create a new column for the formulas in the Power Query.

**Now Follow The Guide ↓ **

**Step_1: **Select the **Data **tab.

**Step_2: **From the **Get & Transform** group, click on the** From Table** command.

The **Power Query Editor** window will show up on the screen.

**Step_3: **Click on the** Add Column** tab.

**Step_4: **From the **General **group, select the **Custom Column** option.

The **Custom Column** wizard will pop up.

**Step_5: **Insert a column name in the **New Column Name** box.

I gave the column name – **Price (15% VAT)**.

**Step_6: **Insert the formula in the **Custom Column Formula** box.

But I have noticed, as I wrote the formula, a text saying “**Token Eof Expected”. Show Error**” become visible in the bottom part of the box.

If this message appears in the **Power Query**,

**Step_7: **Click on the “**Show Error**”.

**Step_8: **Correct the errors.

My error in the formula is, that I used the** ‘%’ sign**.

So I altered the ‘**%’ **into **15/100**.

Now a message saying** “No syntax errors have been detected”** will be displayed.

**Step_9: **Click on the **OK **button.

**Step_10: **Select the **Home **tab.

**Step_11: **Click on the **Close & Load** drop-down menu.

**Step_12: **Select the **Close & Load **command.

**Final Result ↓**

The results are presented in a new table now.

**🔗 4+ Ways to Repeat Formula Pattern in Excel**

### Alternative Way #5: Use the VBA code to Copy Formula Down in Excel without Dragging

Those who are familiar with using the **VBA **code can also apply the **VBA **codes to avoid the drag-down method.

**Now Follow The Guide ↓ **

**Step_1: **Select the **Developer **tab.

**Step_2: **Under the **Code **group, click on the **Visual Basic **command.

You can also enter the **Visual Basic Editor** in the Windows versions by pressing **ALT+F11** or **ALT+Fn+F11**.

Another shortcut to enter the **Visual Basic Editor: **Right-click on the current worksheet and select **View Code**.

The **Visual Basic Editor **will come along on the screen.

**Step_3: **Click on the** Insert **drop-down menu.

**Step_4: **Select the** Module **option.

**Step_5: **Enter the codes presented below:

```
Sub Price_Calculator()
Dim gRc As Long
Dim g As Long
gRc = Cells(Rows.Count, "B").End(xlUp).Row
For g = 2 To gRc
Cells(g, "C").Value = Cells(g, "B").Value + (0.15 * Cells(g, "B").Value)
Next g
End Sub
```

**Step_6: **Click on the **Run **menu.

**Step_7: **Select the option **Run Sub/UserForm **(or press **F5**).

**Step_8: **Close the **Visual Basic Editor** (or press **ALT+F4** or **ALT+Fn+F4**).

**Step_9: **Now from the **Code **group, click on the **Macros **command.

The **Macro **dialog box will pop up.

**Step_10: **Click on the **Run **button.

**Final Result ↓ **

You have your desired result now.

**🔗****How to Copy a Formula in Excel to Another Sheet (4+ Solutions)**

### Alternative Way #6: Use the CTRL+D and CTRL+R shortcut Keys

I am going to use a different example here to show you how to use** CTRL+D **and** CTRL+R **shortcut commands.

**Now Follow The Guide ↓ **

**Step_1: **Type the formula in** cell C5**:

**=$B5+$B5*C$2**

**Formula Explanation**

**$B5**means, the**$ sign**is going to lock**column B**and change the row number in the order of**B5, B6, B7, B8,…B13**.**C$2**is the fixing of row number but changing the column number. That means**C2**will be**D2**if I move the formula to the right side direction.

**Step_2: **Press **ENTER **to apply the formula.

**Step_3: **Select the cells from **C5 **to **D13**.

**Step_4: **Press **CTRL+D** to apply the formula in the down direction.

**Step_5: **Press **CTRL+R** to copy the formula to the right side direction.

**Final Result ↓ **

This way you can copy a formula in more columns on the right side.

**🔗 Apply Same Formula to Multiple Cells in Excel (5+ Solutions)**

### Alternative Way #7: Use the CTRL+ENTER to Copy Formula Down in Excel without Dragging

If your data table has small numbers of cells, this is another fast technique to copy formulas without dragging.

**Now Follow The Guide ↓ **

**Step_1: **Mark all the cells of **column C**.

**Step_2: **Type the formula in the top cell (**cell C2**).

**Step_3: **Press **CTRL+ENTER.**

**Final Result ↓ **

That’s a very 3-step easy technique for copying formulas in Excel.

**🔗 ****How to Copy a Formula in Excel to Another Sheet (4+ Solutions)**

### Alternative Way #8: Shortcut Keys to Copy Formula Down in Excel without Dragging

This approach is suitable for those who are more into using the keyboard always. You don’t need to touch the mouse cursor for once in this entire procedure.

**Now Follow The Guide ↓ **

**Step_1: **Press **CTRL+C** to copy **cell C2**.

**Step_2: **Press the **Right arrow ‘←’ key** to move to **cell B2**.

**Step_3: **Press **CTRL+Down arrow ‘↓’ key** to straight away go to the last cell **(cell B10)** of **column B**.

Now you are probably thinking, why I did not move to **cell C10** from **cell C2**. It’s because there is no value in **cell C10**, so we can not proceed directly in **C10**.

**Step_4: **Now press** CTRL + SHIFT + Up arrow ‘↑’ key**.

This will select the cells of the range **C2:C10**.

**Step_5: **Press **CTRL+V **to paste the formula.

**Final Result ↓ **

This is a very handy technique to apply.

**🔗 Copy Excel Sheet to Another Sheet with Same Format and Formulas**

## Conclusion

I have tried to show you all the feasible methods to copy formulas without dragging down the Fill Handle like always. Now you can apply one of the methods whichever you prefer. Leave a comment in the comment section if you have anything to say about this article. Have a good day!