Excel Insert Paste Row: Add Copied Rows Correctly

To insert a copied row in Excel without overwriting existing data, select its row number, press Ctrl+C, right-click the row number where the copy should go, and choose Insert Copied Cells. Excel adds the copied row above that position and shifts the existing rows down; ordinary Ctrl+V pastes into cells and can replace their contents instead.

Insert a copied worksheet row

These steps apply to Excel for Microsoft 365 on Windows. Selecting the row header—the numbered box at the left edge of the worksheet—copies or targets the entire worksheet row, rather than just the cells that happen to contain data.

Click the number of the row you want to duplicate. The whole row should be highlighted.
Press Ctrl+C, or right-click the selected row number and choose Copy. A moving dashed outline around the row indicates that it is on the clipboard.
Find the row above which the copy should appear. Right-click that row’s number, not a cell inside it.
Choose Insert Copied Cells from the context menu.

For example, to duplicate row 5 above row 8, copy row 5 by clicking its header, then right-click the header for row 8 and select Insert Copied Cells. The copy becomes the new row 8, and the old row 8 and the rows below it move down. The source row remains in place.

To put the copy at the bottom of a data list, select the first blank row beneath the list as the destination. Excel inserts the copied row above that blank row. If you want it after the current last row, target the blank row immediately following it.

Why ordinary paste can replace data

Copying and pasting are different from inserting. When you select a destination cell and press Ctrl+V, Excel pastes the copied contents starting at that cell. If those cells already contain information, the pasted contents replace it. The cells are not automatically moved out of the way.

Insert Copied Cells instead makes room for the copied content. When you copied a complete worksheet row and target a row header, Excel inserts a complete row. This is usually the clearest choice when your aim is to duplicate a record without disturbing the records beneath it.

There is also a useful two-step method: create a blank row first, then paste into it. Select the destination row header and choose Home > Insert > Insert Sheet Rows. Then select the first cell of the new row and paste. This separates the act of making space from the act of filling it, which can be easier to troubleshoot.

Copying a whole row or only part of one

Copy a whole row when the information belongs together across multiple columns, or when you want its formatting and other row-level contents carried over. Clicking the row number selects all columns, including currently empty cells. It is not necessary to drag across the visible data.

If you only need a few cells, select and copy that range instead. Right-click the same-sized destination range and look for Insert Copied Cells. Excel may ask whether to shift existing cells right or down. Choose the direction that preserves the surrounding layout. A partial-range insertion is not the same as inserting a whole worksheet row, so check adjacent columns before confirming.

For instance, if a sheet has employee names in A and notes in B through D, inserting copied cells only in A may shift names without moving their corresponding notes. In that case, either select the full row or select the complete A:D record range before inserting. Keeping related fields together prevents records from becoming mismatched.

Adding a row inside an Excel table

An Excel table is a formatted data region with features such as filter buttons and structured references. A table row is not quite the same thing as a worksheet row. If the data is in a table, you can right-click a cell in the table row where you want space and choose Insert, then Table Rows Above. The wording can vary slightly depending on the selection and Excel build.

For a copied table record, insert a table row first and then paste the values into the new row, or use the table’s context menu if Excel offers an insert-copied-cells option for that selection. Confirm that the new record remains within the table: its filter and table formatting should continue, and the table’s range should include the row. Pasting below a table may put data on the worksheet without extending the table, depending on how it is pasted and what is adjacent.

Tables may automatically fill calculated-column formulas or extend formatting when a new row is added. Check the new row’s formulas and values, especially if the copied record came from another table or workbook. Do not assume that a visually matching row is necessarily part of the table.

What happens to formatting and formulas

Inserting copied cells carries the copied cells’ contents and formatting, so the new row may inherit borders, number formats, fills, and font styling from the source. That is helpful for duplicating a consistent record, but it can also bring over formatting you did not want. If the destination should keep its existing appearance, consider inserting a blank row and using a paste option that suits the task, or adjust formatting after the insert.

Excel generally adjusts ordinary cell references when rows are inserted. For example, inserting a row within a referenced range can change the range so it continues to include the relevant cells. The result depends on the formula and where the row is inserted, so review important totals and calculations after a structural change. Formulas that build references from text, such as some uses of INDIRECT, may not respond in the same way as ordinary direct references.

Copying a formula is also different from moving its source. Relative references can change in the copy to reflect its new position; absolute references marked with dollar signs, such as $A$1, remain fixed. If a duplicated row contains formulas, inspect at least one of them to make sure the new row refers to the intended cells.

Shortcuts and menu alternatives

On Windows, Ctrl+C copies the selected row and Ctrl+V performs an ordinary paste. Ctrl+Shift++ (often entered as Ctrl+Shift+= on a standard keyboard) opens Excel’s insert action for a selected row or cells; it is useful for adding blank space, but the right-click Insert Copied Cells command is the more direct option when you specifically need to insert what is on the clipboard.

The ribbon alternative for inserting a blank worksheet row is Home > Insert > Insert Sheet Rows. You can also right-click a row number and choose Insert. On a Mac, use the same row-header context-menu approach or the Home tab’s Insert controls; copy and paste commonly use Command+C and Command+V rather than Ctrl+C and Ctrl+V. Keyboard mappings can depend on the Mac keyboard and Excel settings, so the menu command is a reliable alternative.

Common problems and how to fix them

Insert Copied Cells is missing: Confirm that you copied cells first and that the moving dashed border is visible. Right-click the destination row number for a full-row copy, rather than right-clicking a cell.
The old data was replaced: That usually means ordinary paste was used. Undo immediately with Ctrl+Z if appropriate, then copy again and use Insert Copied Cells, or insert a blank row before pasting.
The wrong cells moved: If you copied only part of a row, Excel may offer to shift cells in a direction that disrupts neighboring data. Cancel and select the full record or the entire worksheet row instead.
The command is unavailable: A protected worksheet may restrict inserting rows. Check Review > Unprotect Sheet if you have permission to unprotect it. Merged cells or a selection that does not match the copied range can also complicate insertion.
The row appears in the wrong place in filtered data: A filter hides rows; it does not remove them. Inserting at a visible row header can affect the worksheet’s row structure, including hidden rows. Consider clearing or changing the filter, inserting the row, and then checking the filtered results.
There is no room at the bottom: Excel worksheets have a limit of 1,048,576 rows. If an insertion would push cells beyond the worksheet’s last row, Excel cannot complete it; remove or relocate unnecessary content at the bottom first.

For a mistake made during the current session, Ctrl+Z usually reverses the last insertion. If you have made several later edits, undo may reverse those edits too, so check the result after each undo. Saving a separate copy before a large reorganization is a sensible precaution.

Frequently Asked Questions

How do I insert a copied row in Excel without overwriting?
Copy the row by clicking its row number and pressing Ctrl+C. Right-click the destination row number and choose Insert Copied Cells. Avoid selecting a destination cell and using ordinary Ctrl+V if existing data must move down.

Does Excel insert a copied row above or below the selected row?
When you right-click a destination row header and choose Insert Copied Cells, Excel inserts the copy above that row. To place it after your data, target the blank row immediately below the last record.

Can I insert several copied rows at once?
Yes. Select the row headers for the adjacent source rows, copy them, then right-click the destination row header and choose Insert Copied Cells. Check that the selected destination is where the top copied row should begin and that the existing rows have shifted as intended.

What is the difference between Insert Copied Cells and Insert Sheet Rows?
Insert Copied Cells makes room and places the copied content in that space. Insert Sheet Rows adds blank worksheet rows; you then paste or enter content separately.

Can I insert a copied row in Excel for Mac?
Yes. Copy the row, right-click or Control-click the destination row number, and choose the insert-copied-cells command if it is available in the menu. You can also use Excel’s Home tab Insert controls; the menu route avoids differences in keyboard shortcuts.

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.