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.
- 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. - Press
Ctrl+C. A moving dashed outline around the copied row indicates that Excel still has it on the clipboard. - Click the row number where the new copy should appear. For example, select row 8 to insert a copy above the current row 8.
- Press
Ctrl+Shift++. On many keyboards, the plus sign is typed withShiftand the equals key, so the keystroke isCtrl+Shift+=. - 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+Xand 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+Zimmediately, 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
Shiftwith 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
- Excel File Too Large? How to Make It Smaller in Excel
- Excel File Too Large to Email? Practical Fixes
- Excel File Size Too Large? How to Reduce It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Shared Mailbox to Outlook on Any DeviceTo add a shared mailbox to Outlook, first ask your Microsoft 365 or Exchange administrator to give your…
- Slicer Shortcut Key in Excel: Insert and Use SlicersExcel does not have one dedicated, built-in keyboard shortcut that inserts a slicer. In Excel for Microsoft 365…
- Copy Excel to Word Without Losing FormattingTo copy Excel cells into Word without losing their appearance, select the range in Excel, press Ctrl+C, then…
- Split Cell Contents Into Multiple Columns in ExcelYes. In Excel for Microsoft 365 on Windows, select the cells and choose Data > Text to Columns…
- Microsoft Word Styles and Formatting: A Practical GuideMicrosoft Word styles are named sets of formatting—such as font, size, spacing, and paragraph alignment—that you can apply…
- Excel Keyboard Shortcuts: What You Can Customize in ExcelIn Excel for Microsoft 365 on Windows, you cannot directly remap most built-in keyboard shortcuts through an Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.