4 Ways to Fill Formula Down to Specific Row in Excel

Sometimes you may need to copy down a formula to a specific row, but not the entire column. To copy a formula either in the specific rows of a column or up to a specific row 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.

To fill a formula down to a specific row in Excel:

1. Enter the formula in the starting cell.
2. Select the cell with the formula.
3. Use the Fill Handle (bottom-right corner) to drag it down to your desired row. Release the mouse.
   Or,
4. Go to the “Home” tab, “Editing” group, “Fill” dropdown, and select “Down.”
   Or,
5. Press CTRL+D to quickly fill the formula down to the specific row.

On my 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 is 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.

Fill Formula Down to Specific Row in Excel Using a Keyboard Shortcut

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 these steps:

1. Enter your formula in the cell where you want to start the series.
   I have used a formula for adding 15% VAT to the basic price of some fast-food items.
2. Click on the cell with the formula to select it.
   
3. Now press and hold the CTRL key and select the specific cells you want them to fill with the formula.
   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.
4. While holding “CTRL” press the “D” key. This keyboard shortcut fills the formula down.
   You will see the formula filled up in cells C2, C4, C6, C8, and, C10.

• 9 ways to Copy Formula Down in Excel without Dragging
• Copy Excel Sheet to Another Sheet with Same Format and Formulas

Using the Fill Down Command to Fill Formula Down to a Specific Row in Excel

Here, I’m going to use the Fill Down command to fill down a formula to a specific row in Excel. Follow these steps:

1. Enter your formula in the cell where you want to start the series.
2. Click on the cell with the formula to select it.
3. Go to the “Home” tab in the Excel ribbon.
4. In the “Editing” group, you’ll find the “Fill” dropdown menu.
5. Click on the “Fill” dropdown menu and select “Down” from the options. This will fill the formula down the column until the next empty cell is encountered.

• 6+ Ways to Copy a Formula in Excel with Changing Cell References
• 3 Ways to Copy a Formula in Excel without Changing Cell References

Fill a Formula Down to a Specific Row in Excel with Fill Handle

You can use the Fill Handle tool to fill any formula down to a specific row in Excel. Here’s how:

1. Enter your formula in the cell where you want to start the series.
2. Click on the cell with the formula to select it.
3. Move your mouse cursor to the bottom-right corner of the selected cell. When the cursor changes to a black cross, this is called the Fill Handle.
4. Click and drag the Fill Handle down to the row where you want to stop filling the formula.
5. Release the mouse button, and Excel will fill the formula down to the specific row you stopped at.

• 5+ Proven Methods to Copy a Formula to Entire Column in Excel
• 4+ Ways to Repeat Formula Pattern in Excel

Remove Unnecessary Rows to Fill Down a Formula to a 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.

Here’s the step-by-step guide:

1. Apply a formula in cell C2.
2. Select the unnecessary rows.
   In my case, I have chosen Row 6.
3. Click on the Home tab.
4. Click on the Clear drop-down menu from the Editing group.
5. Select the Clear Content command. Row 6 has no values in it now.
6. Now pull down the Fill Handle from cell C2 to C10. 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

In conclusion, I hope that the four methods discussed in this article will provide you with a solution to the issue of filling a formula in particular rows in Excel. Please do not hesitate to comment on our blog post. Additionally, please do not hesitate to let us know if you have any queries regarding any Microsoft Excel topic. Thank you.

Frequently Asked Questions

How do you fill a formula down to a specific row in Excel on a Mac?

To fill a formula down to a specific row in Excel on a Mac, follow these steps:

1. Enter the formula in the starting cell.
2. Click on the cell with the formula to select it.
3. Use the Fill Handle (bottom-right corner) to drag it down to your desired row.
4. Release the mouse, and Excel will fill the formula down to the specified row.

These steps apply to both Mac and Windows versions of Excel, ensuring consistent functionality.

How do I apply a formula to an entire column in Excel?

To apply a formula to an entire column in Excel, you can follow these steps:

1. Click on the header of the column where you want to apply the formula. This will select the entire column.
2. Click on the Formula Bar at the top (where you usually type your formulas).
3. Enter your formula in the Formula Bar, and then press CTRL+ENTER. The formula will be applied to the entire selected column.

How do I copy a formula in Excel without scrolling?

When you need to copy a formula in Excel without scrolling, use the “Fill Handle” feature:

1. Select the cell with the formula you want to copy.
2. Position your cursor on the Fill Handle (small square in the bottom-right corner of the cell).
3. Double-click on the Fill Handle to copy down the formula in Excel without scrolling.

It will fill all the cells with the formula until it encounters a blank cell.