Excel Insert Row and Copy Formulas From Above Easily

To insert a row and copy formulas from above in Excel for Microsoft 365 on Windows, right-click the row number where the new row should go and choose Insert. Then select the formula cells in the row above and the corresponding cells in the new row, and press Ctrl+D to fill the formulas down.

Insert a row and fill formulas down

Excel inserts a worksheet row above the row you select. For example, to add a row between rows 4 and 5, right-click the row 5 heading—the number at the left edge of the worksheet—and select Insert. The existing row 5 and the rows below it move down, leaving a blank row 5.

Click the row number below the position where the new row belongs. To insert more than one row, select the same number of row headings first.
Right-click the selected heading and choose Insert. You can also use Home > Insert > Insert Sheet Rows.
Select the source formula cells and the blank cells directly beneath them. For example, select D4:F5 to fill formulas from row 4 into row 5.
Press Ctrl+D. Excel copies the top row of the selection down into the rows below it.

Fill only the columns that should contain formulas. If row 4 has formulas in D:F but a manually entered note in G, select D4:F5 rather than the whole row; this avoids replacing unrelated content. If the new row needs formulas in several separated areas, fill each continuous area separately.

Keyboard shortcuts and Mac differences

For a keyboard-first method on Windows, click a cell in the row where you want the new row, press Shift+Space to select that entire worksheet row, then press Ctrl+Shift++ (the plus key; on many keyboards this means Ctrl+Shift+=). Excel inserts a row above. Next, select the source and destination formula cells and press Ctrl+D.

On a Mac, use the row heading’s context menu or the ribbon if the keyboard shortcut is inconvenient. Excel’s shortcut for inserting rows can depend on the keyboard layout; on many layouts, Control+Shift+= inserts cells or rows. The fill-down shortcut is generally Control+D. For copy and paste, Mac uses Command+C and Command+V instead of Ctrl+C and Ctrl+V. Excel for the web also supports the ribbon and context-menu methods, though its available shortcuts can vary by browser and keyboard settings.

The menu route is the clearest option when you are unsure which shortcut applies: select the row heading and use Home > Insert > Insert Sheet Rows. Do not confuse this with inserting cells. If you select only a few cells and choose an insert-cells command, Excel may ask whether to shift cells down or right, which can disrupt the layout of a table.

What happens to formulas when you copy them

When you fill a formula down, Excel normally adjusts relative cell references to match the destination row. This is why copying a formula from the row above is usually preferable to typing a new one: the references adapt automatically. The formula’s calculation pattern stays the same, while references that point to particular cells can move.

For example, assume B4 contains a unit price of 12, C4 contains a quantity of 3, and D4 is the line-total column. If D4 contains =B4*C4, its result is 36. After filling D4 down into D5, Excel adjusts the formula to refer to B5 and C5. If B5 is 8 and C5 is 4, the copied formula returns 32.

Not every reference should move. A dollar sign locks a row or column in a reference. Suppose F1 contains a tax rate of 8%, B4 contains a taxable amount of 100, and C4 calculates the tax. With that layout, =B4*$F$1 in C4 returns 8. When filled into C5, the amount reference changes to B5, but the tax-rate reference stays at F1. This distinction matters in worksheets with fixed rates, lookup cells, or shared assumptions.

Excel also adjusts references when rows are inserted, but the result depends on where the referenced cells are and what operation you perform. Inserting a worksheet row is different from copying a formula into that row. After an important structural change, check a few formulas and their results rather than assuming every reference represents the intended business rule.

Using Excel Tables for recurring formula rows

If your data is a formatted Excel Table, it may be easier to add the new row inside the table than to insert a worksheet row around it. Click a cell in the table, right-click, and choose Insert > Table Rows Above. A table can expand to include the new row and often carries a calculated-column formula into it automatically.

Calculated columns use a consistent formula pattern for a table column. For instance, a table column called Line Total might calculate price multiplied by quantity for each record. When you enter a formula in a calculated column, Excel commonly fills it through the column and applies it to added table rows. The formula may use structured references such as column names rather than ordinary cell addresses, which can make it easier to read as the table grows.

Automatic filling is not guaranteed in every workbook. A column with inconsistent formulas, manually overwritten cells, or a changed application setting may not behave as expected. Inspect the formula in the inserted row and compare it with nearby table rows. You can still use Fill Down on the relevant table cells if needed. A table is especially useful for expanding datasets because sorting, filtering, and formulas are designed to work with the table as a growing unit.

Other ways to copy formulas from above

Copy and paste is useful when you want to copy both formulas and formatting, or when the destination cells are not directly below the source. Select the formula cells above, press Ctrl+C, select the corresponding cells in the inserted row, and press Ctrl+V. On a Mac, use Command+C and Command+V. Because regular paste also carries formatting and other cell content, it may overwrite a number format, border, or value in the destination.

Drag the fill handle when you need to fill a short stretch of adjacent rows. Select a formula cell and drag the small square at the lower-right corner of its selection down. This is convenient for one column, but less precise for a wide worksheet or a large destination range. Check that the drag reaches the intended last row.

Use the Fill command when you prefer the ribbon: select the source row and the rows to fill, then choose Home > Fill > Down. Ctrl+D performs the same basic fill-down action for the selected range. In each case, the top row of the selection is the source, so include it when selecting the range.

If you want the result of a formula without carrying the formula itself, use Paste Special and choose values after copying. That is a different goal from copying a formula: pasted values will not recalculate when the inputs change. Choose the method based on whether the inserted row should remain linked to its inputs.

Common problems and how to fix them

The new row is in the wrong place. Excel inserts above the selected row. Undo with Ctrl+Z on Windows or Command+Z on Mac, select the heading below the intended position, and insert again.
The formula copied but shows an unexpected result. Look at the formula bar and compare the references with the row’s inputs. Relative references may have shifted as intended, while an absolute reference may be locked to the wrong cell.
Only some columns filled. Fill Down affects the selected range. Include both the source cells and the destination cells, and make sure the source row is at the top of the selection.
A blank or incorrect formula was copied. Ctrl+D takes the top cell of each selected column as its source. If that cell is blank or contains a different formula, Excel will reproduce that content. Select a correct source row or copy from another row with the intended pattern.
Formatting changed unexpectedly. Filling down can copy cell formatting as well as formulas. If you need the formula but want to keep the destination’s appearance, use Paste Special options or restore the intended number format and borders afterward.
Excel did not add a formula automatically. This is common in ordinary ranges, where formulas do not always extend into a newly inserted blank row. Fill the formula manually with Ctrl+D or copy and paste it, then verify the references.

It is also worth distinguishing a formula that returns zero or an error from a formula that was not copied. Click the destination cell and inspect the formula bar. If it contains a formula, check its inputs, cell formats, and references. If it is empty, the fill range or source selection was likely the issue.

Choosing the right insertion method

Use Insert Sheet Rows when the new record needs a full worksheet row and the surrounding columns should move down together. Use Table Rows Above when working inside an Excel Table, because it adds a record to the table structure. Insert individual cells only when the sheet’s layout genuinely calls for shifting a limited area and you have checked that neighboring columns will remain aligned.

Before inserting rows into a shared or complex workbook, consider whether formulas, charts, named ranges, or other sheets refer to the affected area. Excel often updates direct references when rows are inserted, but a workbook may also contain text-based references, external links, or carefully arranged ranges that need review. Saving a copy before a substantial structural edit is a sensible precaution, especially in a workbook used for reporting.

For a one-off blank row, inserting the row and filling formulas down is quick and predictable. For a dataset that grows regularly, converting the range to a Table can reduce repetitive work and make formulas easier to maintain. Neither approach removes the need to check the new row’s inputs and formula pattern.

Frequently Asked Questions

Does Excel automatically copy formulas when I insert a row?
Sometimes, particularly in a Table with a consistent calculated column, but a newly inserted blank worksheet row may remain blank. If the formula is missing, select the source and destination cells and use Ctrl+D, or copy and paste the formula.

How do I copy a formula down without changing one reference?
Use an absolute reference for the cell that must stay fixed. For example, dollar signs in $F$1 lock both its column and row when the formula is filled. Check the formula bar after filling to confirm the moving references changed and the fixed reference did not.

Can I insert several rows and copy formulas into all of them?
Yes. Select the same number of row headings as the number of rows you want to add, then insert them. Select the formula source row together with the corresponding cells in all new rows and press Ctrl+D. Excel fills the formula pattern through the selected range.

Will Ctrl+D copy formatting too?
Fill Down can copy the top row’s cell contents and formatting into the selected cells. If you need to preserve existing formatting, use an appropriate Paste Special option or check and restore the destination formatting after filling.

Why does my copied formula show the same value as the row above?
The formulas may be using absolute references, referring to unchanged inputs, or using inputs that happen to produce the same result. Compare the actual formulas and input cells; identical displayed results alone do not show whether the copy worked correctly.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.