Excel Shortcut to Insert a Copied Row Without Replacing Data

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, copy the source row with Ctrl+C, select the destination row header, then press Ctrl+Shift++ (usually Ctrl+Shift+= on the main keyboard). If Excel opens the Insert dialog, choose Entire row and press Enter; the copied row is inserted above the selected row instead of replacing its contents.

Fast keyboard method

Use this sequence when you want a duplicate row placed before an existing row. Selecting the row header is important: it tells Excel to work with a whole worksheet row, not just the currently active cell.

  1. Click the source row number at the left edge of the sheet to select the entire row. You can also click a cell in the row and press Shift+Space.
  2. Press Ctrl+C. A moving dashed outline around the copied row indicates that Excel still has it on the clipboard.
  3. Click the row number where the new copy should appear. For example, select row 8 to insert a copy above the current row 8.
  4. Press Ctrl+Shift++. On many keyboards, the plus sign is typed with Shift and the equals key, so the keystroke is Ctrl+Shift+=.
  5. If an Insert dialog appears, select Entire row and press Enter. Check that the new row is above the intended destination.

For example, copying row 4 and selecting row 8 inserts the copied row as the new row 8; the former row 8 and the rows below it move down. If you want the copy at the bottom of a list, select the row immediately below the current last row before inserting.

Why insert copied cells instead of pasting?

A normal paste and an insertion are different operations. If you copy a row, select an existing row, and press Ctrl+V, Excel pastes over the selected cells. That can replace values and formulas already there. Inserting copied cells makes room first, shifting the destination row and following rows downward, then places the copied content in the space created.

This distinction matters when a worksheet contains a list that must retain all its existing records. For instance, to add a duplicate of a product record above another product, use Insert Copied Cells rather than pasting directly onto the other record. If you only need to add a blank row, use the regular Insert command instead; there is no reason to copy a source row first.

Ribbon and right-click alternatives

If the keyboard sequence is inconvenient, Excel provides a command for the same task. Copy the source row, right-click the destination row number, and choose Insert Copied Cells. The row-number menu is useful because it makes the whole-row destination unambiguous.

You can also use the ribbon: after copying the row and selecting the destination row header, choose Home > Insert > Insert Copied Cells. The Insert command is in the Cells group on the Home tab. Depending on the current selection and Excel build, the command may be shown in the Insert dropdown. These routes are particularly helpful if the shortcut opens a dialog or if a laptop keyboard makes the plus key awkward to reach.

On a Mac, copy with Command+C and use the Insert menu or row-header context menu if your keyboard mapping does not match the Windows shortcut. Excel for Mac commonly uses Control+Shift+= for inserting cells, but keyboard layouts and key labels differ; the menu command is the dependable fallback. Excel for the web also offers row-header context-menu commands, though available shortcuts can depend on the browser and operating system.

How to choose the correct destination

Excel inserts a copied row above the row you select, not below it. This is the detail that most often causes the copy to land one row away from the intended position. Before inserting, identify the row that should move down and select its row number.

  • Insert above a record: select that record’s row header.
  • Insert between two records: select the lower record’s row header.
  • Append at the bottom: select the first empty row beneath the list.
  • Move rather than duplicate: cut the source row with Ctrl+X and insert the cut cells at the destination, taking care not to confuse a move with a copy.

When inserting several copied rows, select the same number of destination rows before using Insert Copied Cells. For example, copying three complete rows and selecting three destination row headers gives Excel a matching-sized space to insert. If the selected destination range is a different size, Excel may display a prompt or produce a result that is not what you intended, so check the selection before confirming.

Working with rows in an Excel table

An Excel table is a formatted data range with features such as filter buttons and structured references. A table is not quite the same as an ordinary worksheet range. When adding a record inside a table, use a row within the table as the destination and check that the inserted record remains part of the table. In some situations, selecting a worksheet row header can affect the sheet row, while selecting cells inside the table focuses the operation on the table area.

For a table, a practical alternative is to right-click a cell in the table row where the copy belongs and use the table’s insert options, or use the table’s last row to add a record. Then verify that the new row inherits the table style and that filter buttons and calculated-column formulas still behave as expected. Avoid inserting an entire worksheet row when you only mean to add a record to a table that shares sheet rows with unrelated data elsewhere.

If the copied row contains formulas in a table, Excel may adjust or fill calculated-column formulas according to the table’s rules. Review formulas in the inserted record rather than assuming that every reference remains identical to the source.

What Excel copies with a row

Copying a full worksheet row can carry more than its visible values. It can include formulas, formatting, number formats, data validation, comments or notes, and other cell-level content. When the row is inserted, Excel also adjusts relative formula references as it would for a copied range. A formula that referred to a nearby cell may therefore point to a correspondingly shifted cell in the new row; absolute references marked with dollar signs behave differently.

Formatting deserves a quick check. If the source row has a fill color, borders, or number format that differs from the surrounding rows, the inserted row can preserve that appearance. This may be exactly what you want when duplicating a template record, but it can make a list look inconsistent when the copied row has special formatting. Use Paste Special or copy only selected cells if you need to control what comes across, rather than duplicating an entire row.

A full worksheet row spans all columns, not just the columns currently visible in your list. Excel worksheets have 1,048,576 rows and 16,384 columns, so copying an entire row can bring along content or formatting far to the right of the data you are viewing. If the sheet has unrelated information in those columns, consider selecting and copying only the relevant range instead.

Common shortcut problems and fixes

If nothing happens, or the wrong cells move, check the selection and clipboard before repeating the command. The most useful troubleshooting steps are:

  • The copy outline is gone: copy the source row again with Ctrl+C. Another copy or cut operation can replace the clipboard contents.
  • You overwrote a row: press Ctrl+Z immediately, then select the destination row header and use Insert Copied Cells. Undo is available for ordinary worksheet edits, but not for every action such as running a macro.
  • An Insert dialog appears: choose Entire row when the intention is to insert a complete worksheet row. If you meant only a block of cells, choose the appropriate shift direction instead.
  • The wrong row moved: remember that the new copy goes above the selected row. Undo and select the row that should be pushed downward.
  • The shortcut types a plus sign or does not register: on some keyboards, the plus key requires Shift with the equals key; layouts and numeric keypads differ. Use the row-header context menu or ribbon command as a fallback.
  • The sheet is protected: protection settings may prevent inserting rows. The workbook owner may need to allow row insertion or unprotect the sheet before the operation can proceed.

Also check whether the worksheet has a filter or hidden rows. Inserting a row into a filtered list can make it less obvious where the new record appears, and hidden rows can affect what you see without changing the underlying row order. Clear or inspect filters if the result is difficult to locate.

Frequently Asked Questions

What is the shortcut to insert a copied row in Excel?
On Windows, copy the row, select the destination row header, and press Ctrl+Shift++ (usually Ctrl+Shift+=). If prompted, choose Entire row. The right-click command Insert Copied Cells is an alternative.

Does Excel insert the copied row above or below the selected row?
It inserts the copy above the selected row. To place a copy after the last record, select the first empty row below the list before inserting.

How do I insert a copied row without overwriting the existing row?
Do not use ordinary Ctrl+V on the existing row. Select its row number and use the insert-copied-cells shortcut, ribbon command, or row-header context-menu command so Excel makes room first.

How do I insert a blank row instead of a copied row?
Select the row header where the blank row should appear and use Ctrl+Shift++, then choose Entire row if Excel displays the Insert dialog. You do not need to copy anything when the new row should be empty.

Can I insert more than one copied row at a time?
Yes. Copy the required number of complete rows, select an equal number of destination row headers, and invoke Insert Copied Cells. Confirm the result before continuing, especially if the rows contain formulas or formatting that need to be checked.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.