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.

Applying a formula to Fill Formula Down to Specific Row in Excel

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.

Selected Rows to Fill Formula Down to Specific Row in Excel

Step_4: Press CTRL+D.  

Final Result ↓ 

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

Press CTRL+D to Fill Formula Down to Specific Row in Excel

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

Randomly Selected Rows to Fill Formula Down to Specific Row in Excel

Step_3:  Select the Home tab.

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

Use the Fill drop-down to Fill Formula Down to Specific Row in Excel

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.

Result of Filling Formula Down to Specific Row in Excel

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

Fill Formula Down to Specific Adjacent Row in Excel

Step_3: Release the right mouse button.

Final Result ↓

The formula is now applied from cells C2 to C7.

Use Fill Handle to Fill Formula Down to Specific Adjacent Row in Excel

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

Remove Unnecessary Rows to Fill Formula Down to Specific Row in Excel

Final Result ↓

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

Remove Unnecessary Rows before Filling Formula Down to Specific Row in Excel

🔗 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

(Visited 692 times, 3 visits today)

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *