To copy an entire row in Excel for Microsoft 365 on Windows, click the row number at the left edge, press Ctrl+C, select the destination row number, and press Ctrl+V. This copies the row’s contents and formatting across the worksheet; if you need to keep existing rows and add a duplicate between them, use Insert Copied Cells instead. Before pasting, check that the destination is the row you intend to replace or shift.
What You’ll Need
- A workbook open in Excel for Microsoft 365. The steps also work in many recent desktop versions of Excel.
- A source row with the information you want to duplicate, and a destination row or position.
- Permission to edit the worksheet. A protected sheet may prevent copying or pasting.
- If copying between worksheets or workbooks, both the source and destination should be open, and you should know which sheet and row will receive the copy.
You do not need to select individual cells or know the number of columns in the worksheet. Selecting a row by its number targets the full worksheet row, including cells that look blank.
Step-by-Step
- Open the worksheet and find the source row. Locate the row containing the information you want to copy. Check the row number on the left and scan the row before copying, especially if nearby rows contain similar records. If a filter is active, remember that rows hidden by the filter are still part of the worksheet; selecting a row by its number is not a way to select only the visible cells in that row.
- Select the full source row. Click its row number in the gray row-heading area along the left side of the grid. The full row should become highlighted from the first column through the last column, not just the cells currently visible on screen. You can also click a cell in the row and press Shift+Space to select the entire row. On a Mac, Shift+Space also selects the row.
- Copy the selected row. Press Ctrl+C on Windows. A moving dashed border around the selected row indicates that Excel has copied it to the clipboard. You can also use Home > Copy on the ribbon. On a Mac, press Command+C, or use Home > Copy. Keep the selection active while you choose where the copy should go.
- Choose the destination carefully. If you want the copied data to replace the contents of an existing row, click that destination row number. If you want to create a new row and keep the existing rows, choose the row number where the new row should appear; you will use Insert Copied Cells in the next step instead of ordinary paste. When copying to another worksheet, click that sheet’s tab first, then select the destination row number. For another workbook, switch to its window and select the target sheet and row.
- Paste the row or insert a duplicate. For a straightforward copy, press Ctrl+V on Windows or Command+V on a Mac. The copied row is pasted into the selected row, replacing that row’s cell contents and formatting. To insert a new row without overwriting the destination, right-click the destination row number and choose Insert Copied Cells. Excel inserts the copied row at that position and shifts existing rows downward. On a Mac, Control-click or right-click the row heading to open the context menu; the exact menu appearance can vary by mouse or trackpad settings.
- Check the pasted result. Review the copied cells, number formats, borders, and any formulas. When you copy formulas to a different row, Excel normally adjusts relative cell references to match the new location. References with dollar signs, such as $A$1, are absolute and remain fixed. If the source row includes formatting that should not carry over, undo the paste with Ctrl+Z on Windows or Command+Z on a Mac, then use Paste Special to choose the parts you want.
- Finish the copy operation. Press Esc to remove the moving dashed border when you are done. This does not undo the paste; it only cancels the active copy outline. Save the workbook with Ctrl+S on Windows or Command+S on a Mac, particularly if the copied row contains important data or formulas.
For example, suppose row 8 contains a product record and you want another copy directly below it while preserving the current row 9. Select row 8 and copy it, then right-click row 9’s heading and choose Insert Copied Cells. The new duplicate appears at row 9, and the former row 9 moves down. If you instead select row 9 and press Ctrl+V, the copied row replaces row 9’s existing contents rather than making space.
Common Mistakes
- Selecting only the cells that contain visible data. Dragging across a few cells copies only that range, not the entire worksheet row. Click the row heading if you need the full row, including columns beyond the visible data.
- Pasting over a row that contains information you need. Ordinary paste replaces content in the destination cells. Use Insert Copied Cells when you want to preserve and move the rows already below the insertion point.
- Copying a row from a filtered list and assuming hidden records are excluded. A whole-row selection refers to worksheet rows, including rows hidden by filtering or manual hiding. Check the sheet’s filter and hidden-row state before copying if you must work only with visible records.
- Expecting formulas to remain identical. Relative references may change when moved or copied. Inspect formulas in the pasted row, especially if they refer to a different row, sheet, or range than expected.
- Using Cut when you mean Copy. Ctrl+X moves the selected row rather than leaving the original in place. Use Ctrl+C when the source must remain unchanged.
- Choosing a cell rather than the destination row heading for a full-row operation. Pasting after selecting one cell can place the copied range starting at that cell, and may not behave like a full-row replacement or insertion. Select the destination row number for the clearest result.
Tips
- Use the row headings to make the operation explicit. Clicking the source and destination row numbers helps avoid copying a partial range or pasting into an unexpected starting cell.
- Decide whether to replace or insert before pasting. Ordinary paste is suitable when the destination row can be overwritten. Insert Copied Cells is the better choice when every existing record must stay in the sheet.
- Use Paste Special for a partial copy. After copying, right-click the destination and choose Paste Special, or use Home > Paste > Paste Special. Available options let you paste selected aspects, such as values, formulas, or formatting, instead of everything. The options displayed can vary depending on what you copied.
- Keep an eye on relative formulas. If a copied formula should keep pointing to a particular cell, check whether that reference needs dollar signs in the original formula. Do not assume a pasted formula is unchanged just because its displayed result looks plausible.
- Use Undo immediately if the wrong row changes. Ctrl+Z on Windows or Command+Z on a Mac reverses the most recent paste or insertion, as long as you have not performed later actions that you need to keep. Then repeat the copy with the correct destination.
- Remember the keyboard difference on Mac. Use Command+C and Command+V instead of Ctrl+C and Ctrl+V. The row-selection shortcut Shift+Space is the same. Ribbon commands remain available if a shortcut is intercepted by your system.
Troubleshooting
Nothing happens when you paste: Copy the source row again and look for the moving dashed border. If it is missing, Excel may no longer have the row on its clipboard. Then select the destination row heading and paste again. Also check whether the worksheet is protected or whether a dialog box is waiting for input.
The destination row was overwritten: Press Ctrl+Z immediately on Windows, or Command+Z on a Mac, to undo. Copy the source row again, right-click the row heading where the new copy should go, and choose Insert Copied Cells. Do not paste normally if you need to retain the destination row’s data.
Only some columns changed: You may have selected a cell range rather than the row heading, or copied only part of the row. Undo if necessary, click the source row number, copy again, then select the destination row number. A full-row selection should highlight the row across the worksheet.
Formulas show unexpected results: Click a formula cell in the copied row and inspect its references in the formula bar. Excel adjusts relative references when copying. If you need the source formula to refer to the same fixed cell, edit the formula to use an absolute reference where appropriate, or undo and use a method that preserves the intended references.
Excel will not insert the copied row: Confirm that you copied the row first and that the destination is a worksheet row heading. A protected sheet can block insertion. Merged cells or the layout of a structured table can also limit available insert actions. If the range is formatted as a table, use the table’s row-insertion options and verify that the new record remains inside the table.
The copied row looks different: A full-row copy normally brings formatting along with cell contents. If the destination has a different appearance than expected, undo the operation and try Paste Special with the appropriate option. Check conditional formatting as well: rules on the destination sheet can affect how pasted cells appear.
Frequently Asked Questions
How do I copy an entire row in Excel with a keyboard shortcut?
Click a cell in the row and press Shift+Space to select the full row. Press Ctrl+C, select the destination row, and press Ctrl+V on Windows. On a Mac, use Command+C and Command+V. To keep the destination row’s data, use Insert Copied Cells instead of ordinary paste.
Will copying a row copy its formulas and formatting?
Yes. Copying a whole row and pasting it normally copies its cell contents, formulas, and formatting. Relative formula references can adjust to the new row, while absolute references marked with dollar signs stay fixed. Review formulas if the destination is in a different location.
How can I copy a row without replacing an existing row?
Copy the source row, right-click the row heading where the duplicate should be added, and choose Insert Copied Cells. Excel creates space at that position and shifts the existing rows downward instead of replacing their contents.
Can I copy a row to another worksheet or workbook?
Yes. Copy the source row, switch to the destination worksheet or open workbook, select the target row heading, and paste. If the destination data must remain, use Insert Copied Cells where available. Check formulas and references after copying between sheets or workbooks, because links may point to different locations.
Does copying a row also copy its row height?
When you copy and paste an entire worksheet row, Excel generally carries the row’s height along with the copied row. If the height does not match what you expect, adjust it by dragging the boundary below the row number or using Home > Format > Row Height.
How do I copy only the visible rows in a filtered list?
Do not select whole row headings if hidden or filtered-out records must be excluded. Select the relevant range of cells and use Home > Find & Select > Go To Special > Visible cells only before copying. Check the selection carefully, because copying filtered data can produce a different result from copying one entire worksheet row.
Related
- Excel Screen Lock: How to Unlock a Sheet or Unfreeze Panes
- Close Version History in Excel Without Losing Data
- How to Color an Excel Spreadsheet: Cells, Rows, and More
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Make One Page Landscape in Word Without Rotating All PagesYes. In Word for Microsoft 365 on Windows, select the content for the page, open Layout > Page…
- Google Sheets COUNTIF Contains Text: Formula and ExamplesYes. In Google Sheets, use =COUNTIF(A2:A100,"*text*") to count cells in A2:A100 that contain “text” anywhere; the asterisks are…
- Microsoft Excel Power Query: What It Does and How to Use ItMicrosoft Excel Power Query is a built-in tool for importing data and transforming it into a clean, repeatable…
- Google Sheets SUMIF: How to Exclude Subtotal Rows SafelyTo keep subtotal rows out of a Google Sheets SUMIF result, add a row-type column such as “Detail”…
- Hanging Indent in Word for APA Format: Step-by-StepTo format APA references with a hanging indent in Microsoft Word, select the reference entries, open the Paragraph…
- Freeze Just the Top Two Rows in Excel: A Quick GuideTo keep only the top two rows visible while you scroll in Excel for Microsoft 365 on Windows,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.