Insert Paste Row Shortcut in Excel: Keyboard Guide

In Excel for Microsoft 365 on Windows, copy the row, select the row number where it should go, and press Ctrl+Shift+Plus (+) to insert the copied row above it. If the shortcut is awkward on your keyboard, use Home > Insert > Insert Copied Cells; plain Ctrl+V pastes into cells and may overwrite existing data.

What the insert-paste shortcut does

Excel distinguishes between pasting into a location and inserting copied cells at that location. A regular paste puts the copied contents into the selected cells. If those cells already contain data, that data can be replaced. Insert Copied Cells instead makes room for the copied material, shifting existing cells down, and places the copied row into the space created.

When you select an entire destination row, Excel inserts the copied row above that row. For example, if you copy row 4 and select the row 9 heading before using Insert Copied Cells, the copied row appears as the new row 9. The former row 9 and the rows below it move down. The shortcut is useful for duplicating a record, a set of formulas, or a formatted template row without manually inserting an empty row first.

On many Windows keyboards, the plus sign is typed with Shift and the equals key, so the shortcut may physically be entered as Ctrl+Shift+=. Excel describes it as Ctrl+Shift+Plus. Keyboard layouts vary, so use the ribbon command if the key combination does not behave as expected.

How to insert a copied row with the keyboard

Click the row number at the left edge of the worksheet to select the entire source row. You can also select a cell in that row and press Shift+Space.
Press Ctrl+C. A moving dashed outline, sometimes called marching ants, indicates that the row is on the clipboard.
Click the row number where you want the copy inserted. This is the destination row, and Excel will place the copied row above it.
Press Ctrl+Shift+Plus (+). If Excel opens an Insert dialog rather than inserting the copied row, cancel it and use the ribbon or context-menu method below.

That last check matters: the insert command can open a dialog when Excel does not recognize a copied range, or when the selected destination is not a full row. Selecting the row heading and confirming that the copied-row outline is still visible makes the intended operation clearer.

To insert a copied row at the very bottom of a data list, select the first empty row beneath the list. The copied row will be inserted there, pushing that row and anything below it down. If the worksheet has no content below the list, this produces what looks like a copy at the bottom, but it remains an inserted worksheet row.

Use the ribbon or context menu instead

The ribbon offers a useful alternative when the shortcut is unfamiliar, when a keyboard layout makes Plus difficult to type, or when you want to confirm that Excel is performing an insertion rather than a normal paste.

Select and copy the source row with Ctrl+C.
Select the destination row by clicking its row number.
On the Home tab, choose Insert > Insert Copied Cells.

You can also right-click the destination row number and choose Insert Copied Cells from the context menu. The command name is important: choosing Paste or pressing Ctrl+V is not the same operation. If you do not see Insert Copied Cells, make sure the source cells are still copied and that you have selected the destination row. The command may disappear after another action replaces the clipboard contents.

Insert a blank row, then paste

Sometimes the goal is to create an empty row first and then paste only selected values, formulas, or formatting into it. In that case, select a row heading and press Ctrl+Shift+Plus (+) to insert a blank row above the selection. You can also use Home > Insert > Insert Sheet Rows. Then select the new row or the relevant cells and press Ctrl+V, or choose a paste option from Home > Paste.

This two-step approach gives you more control when the source is not a complete row. For instance, if you copied just columns A through C from a record but want to preserve formulas already in columns D and E, insert a blank worksheet row and paste into A:C only. Inserting a full copied row would bring along the source row’s other cells and could change content you meant to keep.

To insert several copied rows, copy the same number of complete rows and select the same number of destination row headings before using Insert Copied Cells. For example, copy rows 3 through 5, then select destination rows 10 through 12. Excel inserts the three copied rows above row 10. Selecting a mismatched range can produce an unexpected dialog or result, so match the source and destination row counts.

What gets copied along with the row?

Copying a full worksheet row brings more than its visible text. The inserted cells can include formulas, number formats, borders, fill colors, and other cell formatting from the source. Row height may also be relevant when the source has been given a custom height. Review the inserted result if the source row is a carefully formatted heading or template.

Formulas are copied as formulas, and relative references may adjust to the new location. For example, a formula in the source row that refers to the cell immediately above it can refer to the cell immediately above the inserted copy after insertion. Absolute references, which use dollar signs such as $A$1, remain fixed. This is normal Excel reference behavior, but it means a copied formula may calculate differently from a simple duplicated value.

Inserting cells also affects the surrounding worksheet. Formulas elsewhere that refer to shifted cells are often adjusted by Excel, but a workbook with complex references, external links, charts, or macros deserves a quick check after structural edits. If the row contains formulas that must continue pointing at particular cells, inspect them rather than assuming every reference should move in the same way.

Windows, Mac, and Excel for the web

The steps above are written for Excel for Microsoft 365 on Windows. On Windows, Ctrl+Shift+Plus is the insert shortcut; on many keyboards, type it as Ctrl+Shift+=. The ribbon route, Home > Insert > Insert Copied Cells, is a practical fallback if the keyboard layout treats the plus key differently.

In Excel for Mac, keyboard behavior can differ by version and keyboard layout. Control+Shift+Plus is the commonly used insert-cells combination, but the physical keys needed to produce Plus may vary. If it does not work, select the copied row and use the Insert Copied Cells command from the available Insert or right-click menu. The menu command avoids relying on the operating system’s key layout.

Excel for the web also supports copying and inserting rows, though the ribbon and context menus can differ slightly from the desktop application and keyboard shortcuts may be affected by the browser. Use the row-heading context menu or the Home tab’s Insert options if the keyboard command is intercepted or does not produce the expected result. If a workbook is open in view-only mode, you may need editing permission before changing its rows.

Common problems and how to fix them

The existing row was replaced. You likely used Ctrl+V rather than Insert Copied Cells. Undo immediately with Ctrl+Z if appropriate, then copy again and choose Insert Copied Cells.
The Insert dialog appeared. Cancel it, reselect the destination row heading, and use Home > Insert > Insert Copied Cells. Check that the source still has the moving dashed copy outline.
The new row appeared in the wrong place. Excel inserts above the selected destination row. Select the row number that should move down, not the row that should remain above the copy.
The copied row has unexpected formulas or formatting. A full-row copy includes more than displayed values. Consider inserting a blank row and pasting only the required cells or using a paste option such as Values.
Excel refuses to shift cells. Merged cells or a selection that does not match the copied range can prevent a clean insertion. Try selecting complete row headings, or resolve incompatible merged cells before inserting.

If the operation goes wrong, Ctrl+Z usually reverses the most recent worksheet edit. Check the workbook before continuing, especially if you have made other changes since the insertion. In a shared workbook, be mindful that undoing an action may affect your own recent edits, not necessarily changes made by another person.

Rows in an Excel table are different

A formatted Excel table is not exactly the same as a plain worksheet range. Tables have their own row structure, filters, and automatically extending formulas. You can add a table row through the table’s last row or by using the table’s context-menu insertion commands. When you paste a complete worksheet row over or around a table, Excel may not treat the operation as a simple addition of one table record.

For a table, click a cell in the row that should move down, right-click, and look for an insert option that adds a table row above. The wording and available commands depend on where you click. After inserting or pasting, check that the new record remains inside the table boundary and that calculated-column formulas and filters behave as intended. If the source is another table row, copying the relevant cells into a newly added table row can be more predictable than inserting an entire worksheet row.

Frequently Asked Questions

What is the shortcut to insert a copied row in Excel?
Copy the full row, select the destination row heading, and press Ctrl+Shift+Plus (+) on Windows. The copied row is inserted above the selected row. If the shortcut does not work, use Home > Insert > Insert Copied Cells.

Does Ctrl+V insert a row in Excel?
No. Ctrl+V normally pastes into the selected cells and can replace their contents. To make room for copied cells, use Insert Copied Cells, or insert a blank row first and then paste into it.

How do I insert a blank row with a keyboard shortcut?
Select a row heading and press Ctrl+Shift+Plus (+) on Windows. Excel inserts a blank row above the selected row. You can also use Home > Insert > Insert Sheet Rows.

Can I insert multiple copied rows at once?
Yes. Copy multiple complete rows, select an equal number of destination row headings, and choose Insert Copied Cells. The copied block is inserted above the first selected destination row.

How do I insert a copied row on a Mac?
Try Control+Shift+Plus, noting that the keys needed to type Plus depend on your keyboard layout. If the shortcut is inconvenient or does not work, use the Insert Copied Cells command from the menu or destination row’s context menu.

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.