In Excel for Microsoft 365 on Windows, copy the entire row, select the row where the copy should go, and press Ctrl+Shift+= (the plus sign on most keyboards). Excel inserts the copied row above the selected row instead of replacing its contents.
Use the shortcut step by step
The important part is selecting the whole destination row, not just a cell within it. That tells Excel to insert a complete row and keeps the copied row’s columns together. For example, to copy row 5 above row 8, follow these steps:
- Click the row heading labeled 5 to select the whole source row. You can also click a cell in row 5 and press Shift+Space.
- Press Ctrl+C to copy the row. A moving dashed border usually indicates that Excel has copied it.
- Click the row heading labeled 8. This is the insertion point: the new copy will appear above the selected row.
- Press Ctrl+Shift+=. On a standard US keyboard, the equals key also produces the plus sign when held with Shift.
The former row 8 and all rows beneath it move down. The copied row becomes the new row 8. If you want the copy at the end of a list, select the first blank row immediately below the list before using the shortcut.
What the shortcut does
Excel distinguishes between pasting data into cells and inserting copied cells. A normal paste places the copied contents over cells at the destination. Insert Copied Cells makes room for the copied range by shifting existing cells, rows, or columns. When the copied selection and destination are both entire worksheet rows, Excel inserts a full row.
This is useful when a row contains more than values. Copying and inserting can carry its formulas, formatting, notes, and other cell content along with it. What happens to formula references depends on how those formulas are written and where they are moved; Excel adjusts many relative references when it copies formulas. Check important formulas after insertion, particularly if the row contains references to other sheets or carefully constructed ranges.
The shortcut also depends on having a copied range ready. If you have not copied cells, or Excel no longer recognizes a copied selection, Ctrl+Shift+= may bring up the Insert dialog rather than directly inserting the copied row. If that happens, verify that the copy border is still visible and copy the source row again.
Choose the right destination row
The row you select is the boundary above which Excel inserts the copy. This is a common source of confusion: selecting the row below the desired location does not insert the copy underneath that row. It inserts above it, pushing that row down.
- To add a copy before row 12: select row 12.
- To add a copy after row 12: select row 13, assuming that is where you want the new row.
- To add a copy after the last populated row: select the next blank row.
When the destination is a single cell rather than a whole row, Excel may ask how to shift existing cells to make room. The choices depend on the shape of the copied range and the selected destination. Selecting the entire destination row avoids that ambiguity when the goal is to insert a complete worksheet row.
Shortcut, menu, or context menu?
The keyboard shortcut is quick once you know the selection sequence, but the menus are useful when you want to confirm that Excel is inserting rather than overwriting. After copying a row, right-click the destination row heading and choose Insert Copied Cells. In Excel for Windows, you can also use the Home tab’s Insert drop-down and choose Insert Copied Cells when that command is available.
Do not confuse that command with Insert Sheet Rows. Insert Sheet Rows creates a blank row; it does not put the copied row into the worksheet. You can insert a blank row first and then paste into it, but that takes an extra step and can be easier to get wrong than using Insert Copied Cells.
If the shortcut opens an Insert dialog, inspect the selection before choosing an option. When only cells are selected, Excel may ask whether to shift cells down or to the right. For an entire-row copy, cancel if the selection is not what you intended, then select the destination by its row heading and try again.
Inserting a row is different from replacing one
Use Ctrl+V when you intend to paste copied contents over an existing destination range. Use Ctrl+Shift+= with a copied row and a selected destination row when you want to create space and preserve the existing rows. Inserting changes the worksheet’s layout; ordinary pasting does not move the rows below.
For instance, suppose a list has employee records in rows 2 through 20, and you need to duplicate the structure of row 10 above row 15. A regular paste into row 15 can overwrite the existing record there. Insert Copied Cells instead adds a new row 15 containing the copy and moves the former row 15, plus the records below it, down by one row. Review the copied values before saving if the row contains identifiers or data that should be unique.
Also distinguish copying an entire worksheet row from copying only the cells occupied by a record. Selecting the row heading copies all columns in that worksheet row, including blank cells outside the visible table. If you only want a block of data, select that block instead; Excel will insert cells according to the block’s size and may ask how to shift the neighboring cells.
Tables, formulas, and formatting
Excel tables have their own structure, filters, and calculated columns. When inserting a copied row within a table, select a row in the table and check that the new row remains part of the table. The table may extend automatically when a row is inserted within it, but behavior can depend on where you insert and what range you selected. If the copy lands outside the table, table filters and structured references may not include it.
Copied formatting can be helpful when a new record should match the surrounding rows, but it can also carry unwanted styling, borders, or number formats. After insertion, compare the new row with nearby rows. If the appearance is wrong, use the Paste Options control that appears after pasting, or apply the desired formatting from a neighboring row.
Formulas deserve a separate check. Relative references commonly adjust to the new location, while absolute references marked with dollar signs keep their specified row or column fixed. A copied formula can therefore produce a different reference from the original, by design. Confirm the result in any totals, lookup calculations, or formulas that refer to a fixed range.
Common problems and fixes
- The copied row replaces existing data. You likely used Ctrl+V. Undo immediately with Ctrl+Z if appropriate, then copy again and use Insert Copied Cells or Ctrl+Shift+= with the destination row selected.
- A dialog appears instead of an immediate insertion. Check whether a full row is selected and whether the source is still copied. Select the destination row heading, recopy the source if needed, and retry.
- The new row appears in the wrong place. Remember that Excel inserts above the selected destination row. Undo and select the row that should move down.
- The shortcut does not produce a plus sign. On many keyboards, plus requires Shift with the equals key, so the combination is written Ctrl+Shift+=. Keyboard layouts vary; use the right-click command if the key sequence is awkward.
- The row looks different or formulas changed. Review the copied formatting and formula references. Insertion and copying can adjust references; do not assume the new formulas are identical in every respect to the originals.
Excel for Mac and Excel for the web
The steps above describe Excel for Microsoft 365 on Windows. On a Mac, use Command+C to copy. Keyboard mappings for inserting copied cells can vary with the Mac keyboard and Excel version, so the reliable alternative is to copy the row, select the destination row heading, right-click, and choose Insert Copied Cells if it appears. The ribbon or context-menu wording and availability can differ slightly by version.
In Excel for the web, use the row headings and the available context-menu commands if a Windows desktop shortcut is intercepted by the browser or behaves differently. Select the source row, copy it, select the destination row, and look for Insert Copied Cells. If that command is not available in your current web interface, insert a blank sheet row and paste into it, then verify that the copied contents occupy the intended row. Avoid assuming every desktop shortcut behaves identically in a browser.
Frequently Asked Questions
What is the Excel shortcut to insert a copied row?
On Windows, copy the entire row, select the destination row heading, and press Ctrl+Shift+=. Excel inserts the copied row above the selected row.
Does Ctrl+Shift+= insert a blank row or the copied row?
If Excel has a copied range and you select the destination appropriately, it inserts the copied cells. Without a copied range, the shortcut can open the Insert dialog for inserting cells or rows.
How do I insert a copied row below another row?
Select the row immediately below the row you want to follow, then use Insert Copied Cells. Excel inserts above the selected row, so the existing rows move down.
Will inserting a copied row overwrite my existing data?
Inserting copied cells makes room and shifts existing rows; a regular paste can overwrite the destination cells. Confirm that you selected the destination row and used the insert command, not Ctrl+V alone.
Can I use the same shortcut in Excel for Mac?
Keyboard behavior can differ by Mac keyboard and version. Use the row-heading context menu and choose Insert Copied Cells when available, or check the shortcut shown in your Excel menus.
Related
- Excel Repair Software Free Full Version: What Works?
- Excel Repair Tools for XLS and XLSX Files: What Works
- Excel Remove Text and Keep Numbers in a Cell
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Format Numbers in Thousands (K)To show Excel values in thousands with a K suffix without changing the underlying numbers, select the cells,…
- Excel Number Format With Leading Zeros: How It WorksTo display leading zeros in Excel without changing a number’s value, select the cells, press Ctrl+1, choose Number…
- Create a 3 x 8 Sheet of Labels in WordTo create a 3 x 8 sheet of labels in Microsoft Word, open Mailings > Labels > Options,…
- Excel Text to Columns Shortcut Key for Windows and MacIn Excel for Microsoft 365 on Windows, select a cell in the column you want to split, then…
- Share Outlook Calendar URL: Links and AccessTo share an Outlook calendar URL, open Outlook on the web, go to Settings > Calendar > Shared…
- Excel Conditional Formatting Number Formats ExplainedYes—Excel conditional formatting can apply a number format when a rule is true, without changing the cell’s underlying…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.