# 4 Ways to Fill Formula Down to Specific Row in Excel

Sometimes you may need to copy a formula in some specific rows, but not the entire column. To copy a formula either in the specific rows of a column or in the entire column is very easy in Excel. This article shows 4 ways that will help you to fill the formula down to the specific row in Excel.

## Introduction to Dataset

I have a column for various food items (**Column A: Item**). The next column is for the prices of the foods (**Column B: Price**). And the third column for prices with 15% VAT (**Column C: Price 15% VAT**). I am going to use a formula in **Column C: Price 15% VAT **and fill the formula down in the specific rows.

## Quickest Way to Fill Formula Down to Specific Row in Excel

The quickest way to fill a formula in the specific rows is using the keyboard shortcut **CTRL+D**. Here **D** stands for โdownโ.

**Now Follow the Guide โ **

**Step_1: **Type your preferred formula in cell** C2.**

I have used the formula for adding 15% VAT with the basic price of some fast-food items.

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

** **

**Step_3: **Now press and hold the **CTRL **key and select cell **C2****.**

I want to copy the formula in cells **C4, C6, C8,** and **C10**. So first I selected cell **C2, **then selected** C4, C6, C8,** and **C10**.

**Step_4: **Press** CTRL+D**. **ย **

**Final Result โย **

You will see the formula filled up cells **C2, C4, C6, C8, **and**, C10**.

** **

**๐ย 9 ways to Copy Formula Down in Excel without Dragging**

### Alternative Way #1: Use the Fill command to Fill Formula Down to Specific Row in Excel

I am going to show you the use of the **Fill command** in this method.

**Now Follow the Guide โ**

**Step_1: **Apply a formula in the top cell (**cell C2**) of a column (**column C**).

**Step_2: **Press the **CTRL **key and select your desired cells.

I have selected the cells **C4, C5, **and **C6**.

**Step_3: **ย Select the **Home **tab.

**Step_4: **ย Click on the** Fill** command from the **Editing **group.

**Step_5: **From the drop-down menu, hit the **Down **command.

**Final Result โ **

You will find the formula is copied in cells **C4, C5, **and **C6 **now.

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

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

### Alternative Way #2: Use the Fill Handle to Fill Formula Down to Specific Row in Excel

If you want to fill a formula in adjacent rows in Excel, this method will be suitable for you. I will use the **Fill Handle** to show you this approach.

**Now Follow the Guide โ **

**Step_1:ย **Apply a formula in cell **C2**.

**Step_2: **Hold the **Fill Handle** with the right mouse button and drag it over your preferred cells.

I will fill the formula from cells **C2 **to **C7.**

** **

**Step_3: **Release the right mouse button.

**Final Result โ **

The formula is now applied from cells** C2 **to **C7**.

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

**๐ย 4+ Ways to Repeat Formula Pattern in Excel**

### Alternative Way #3: Remove Unnecessary Rows to Fill Formula Down to Specific Row in Excel

I will not recommend this method if your data table is too long. But this method works great if someone wants to copy a formula in almost every row except a few rows.

**Now Follow the Guide โ **

**Step_1: **ย Apply a formula in cell **C2**.

**Step_2: **Select the unnecessary rows.

In my case, I have chosen **Row 6**.

**Step_3: **Click on the **Home **tab. **ย **

**Step_4: **Click on the **Clear **drop-down menu from the **Editing **group.

**Step_5: **Select the** Clear Content **command.

**Row 6** has no values in it now.

**Step_6: **Now pull down the **Fill Handle** from cell **C2 **to **C10**.**ย **

**Final Result โ **

This way you can remove more row contents if needed and fill a formula in the specific rows.

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

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

## Conclusion

I hope the 4 methods of this article will be enough to solve your problems with filling a formula down in specific rows in Excel. Feel free to share your opinion regarding our blog in the comment section. Also, inform us if you have any confusion on any topic of Microsoft Excel. Thank you.

**๐ย Copy Excel Sheet to Another Sheet with Same Format and Formulas**