To copy multiple rows in Excel, select their row numbers, press Ctrl+C, click the destination row number or starting cell, then press Ctrl+V. This copies the selected rows without removing them from their original location. Before pasting, check that the destination will not overwrite information you need to keep.
What You’ll Need
- An Excel workbook open in Microsoft Excel for Microsoft 365 on Windows. The steps also work in many recent desktop versions of Excel.
- The rows you want to copy and a clear idea of where the copies should go. If the rows contain data only in certain columns, you can select just that range instead of entire worksheet rows.
- If you are making a significant change, consider saving a copy of the workbook first. Copying is generally easy to undo, but a backup is useful if you are working with important data.
Step-by-Step
- Open the worksheet and identify the rows. Find the first and last row you want to copy. For example, if the records occupy rows 5 through 8, those are four adjacent rows. Check that you have the right worksheet and that you are copying the intended records, including any header row only if you want another header in the copied block.
- Select the rows using their row numbers. Click the row number 5 at the far left of the worksheet, hold Shift, and click row number 8. Excel highlights the entire block of rows 5 through 8. You can also click row 5 and drag down the row headers to row 8. To select a single row, click its row number. Selecting row headers copies the full rows, including cells beyond the columns currently in use.
- Choose a cell-range selection instead when appropriate. If you only need columns A through D, click A5 and drag to D8, or click A5, hold Shift, and click D8. This selects the four-by-four cell range rather than every column in the worksheet. Use this approach when you do not want to copy unrelated content, formulas, or formatting elsewhere in those rows.
- Copy the selection. Press Ctrl+C on Windows. You can also select Home > Copy on the ribbon, or right-click the selected area and choose Copy. A moving dashed outline usually appears around the copied cells. Copying leaves the original rows in place; do not use Cut if you want to keep them.
- Choose where the copies should go. To paste full rows, click the row number where the first copied row should appear. For example, click row 12 to paste four rows starting there. To paste a selected cell range, click the top-left destination cell, such as A12. Check the destination first: ordinary paste can replace existing cell contents in the area it covers.
- Paste the rows. Press Ctrl+V, choose Home > Paste, or right-click the destination and choose Paste. Excel places a copy at the destination and leaves the source unchanged. When you paste a cell range, its top-left cell goes into the destination cell, and the rest of the range fills the same number of rows and columns.
- Check the result before continuing. Confirm that the first and last copied records are present, that they appear in the intended order, and that formulas and formatting look right. If the pasted rows replaced information, press Ctrl+Z immediately to undo, then choose a safer destination or insert the copied rows instead. Press Esc to clear the moving outline when you have finished copying.
To insert copies without replacing existing rows: Select and copy the source row headers as above. Then right-click the row number where the new rows should go and select Insert Copied Cells. Excel inserts the copied rows at that position and shifts existing rows downward. This is different from pasting over a destination row. If you select cells rather than entire rows, the right-click menu may offer an insert option suited to cells; check the prompt and choose how existing cells should shift.
To copy rows to another worksheet: Copy the selected rows, click the destination worksheet tab, and select the destination row number or starting cell before pasting. If the destination is in another open workbook, copy the rows, switch to that workbook, and paste at the desired location. When the source and destination worksheets have different layouts, use a specific cell-range selection and verify that each field landed in the intended column.
To copy rows that are not next to each other: Excel may not paste a selection of separate areas as one clean block. For example, Ctrl-clicking row 3 and row 7 and copying both can produce an error or an unexpected result. The dependable option is to copy each row or adjacent block separately and paste them in order, or first make a temporary contiguous list of the rows you need. Check the result rather than assuming separate selections will be combined automatically.
Common Mistakes
- Clicking a cell instead of the row number by accident. Clicking one cell selects only that cell, not its entire row. If you mean to copy complete rows, click the numbered headers at the left edge. If you intentionally need only part of a row, select the precise cell range instead.
- Pasting over data that should remain. Ctrl+V replaces the contents of cells in the destination area. It does not automatically make space. Undo right away with Ctrl+Z if necessary, then use Insert Copied Cells from the row-header context menu to shift existing rows down.
- Copying when you meant to move. Copy creates a second version; it does not remove the source. If you meant to relocate data, use Cut and paste, but take care because the original location will be cleared. For a safe first attempt, copy, check the destination, and delete the original only after confirming the copy is correct.
- Selecting too much or too little. Full-row selection includes every column, even columns that look empty. A limited range can omit a needed formula or note. Decide whether you want entire rows or only the populated columns before copying, and check the selection highlight before pressing Ctrl+C.
- Assuming formulas become fixed values. A normal paste copies formulas, and Excel may adjust relative cell references to suit the new location. If you need the displayed results without formulas, use Paste Special and choose Values, then verify the result. Do not choose Values if the copied formulas need to keep working.
Tips
- Use Shift for one continuous block. Click the first row header, hold Shift, then click the last row header. This is usually the quickest way to select many adjacent rows without dragging a long distance.
- Use the Name Box for a precisely sized range. The Name Box is to the left of the formula bar. Enter a range such as A5:D8 and press Enter to select those cells, then copy. For complete rows, enter a row range such as 5:8. This helps when the desired selection is large or exact boundaries matter.
- Keep the source and destination layouts in mind. When you paste a full row, Excel copies across all columns, not just the visible table. If another worksheet has unrelated content in those columns, select and copy only the needed columns instead.
- Use Paste Special for a specific result. After copying, use Home > Paste > Paste Special to choose options such as Values or Formats, where available. The choices control what is transferred; they are not the same as a standard paste. Check the pasted block because changing the paste type can leave out formulas or formatting you expected.
- On a Mac, use the Mac shortcuts. In Excel for Mac, use Command+C to copy and Command+V to paste; use the row headers in the same way. The context-menu option for inserting copied cells is also available. Keyboard shortcuts can differ from Windows, so do not substitute Ctrl-based Windows instructions on a Mac.
- In Excel for the web, use the worksheet controls. Select the row headers or cell range, copy, and paste at the destination. If a browser or device intercepts a shortcut, use the Copy and Paste commands on Excel’s ribbon or context menu instead. Check the pasted range, especially when working in a shared workbook.
Troubleshooting
- Excel says the command cannot be used on multiple selections. The copied areas may be non-adjacent. Select one continuous block at a time, copy it, and paste it before moving to the next block. If you must combine separate records, place them together in a temporary contiguous area first.
- The rows pasted in the wrong place. Undo with Ctrl+Z on Windows, then select the intended destination row header or top-left cell and paste again. Remember that selecting a cell and selecting a row header are different: the former anchors a cell-range paste, while the latter is appropriate for full rows.
- Existing information disappeared. If you have not made more changes since the paste, press Ctrl+Z immediately. Then copy the source again if necessary and use Insert Copied Cells on the destination row header. If undo is no longer available, restore a saved version or recover the information from a backup rather than continuing to edit over it.
- The copied formulas show different results. Excel normally adjusts relative references when formulas are pasted elsewhere. Check the formula bar in the copied cells. If the destination should refer to the original fixed cells, the formula may need absolute references, such as dollar signs in a reference; if you only want the current results, paste values instead.
- Some formatting or content is missing. Confirm that you copied the full row or the complete intended cell range, not just a portion. If only values were pasted, formulas and formatting may not transfer. Copy the source again and use a standard paste, or choose the suitable Paste Special option. Also check whether the worksheet is protected, since protection can prevent changes to certain cells.
- Keyboard shortcuts do not work. Click a worksheet cell or row header first so Excel has focus, then try the shortcut again. On Windows, use Ctrl+C and Ctrl+V; on Mac, use Command+C and Command+V. In a browser, a shortcut may be handled by the browser, so use the ribbon’s Copy and Paste commands instead.
Frequently Asked Questions
How do I copy several rows at once in Excel?
Click the first row number, hold Shift, and click the last row number to select a continuous block. Press Ctrl+C, choose the destination, and press Ctrl+V. Use Command+C and Command+V in Excel for Mac.
How do I copy multiple rows without overwriting other rows?
Copy the source rows, right-click the row number where they should be added, and choose Insert Copied Cells. Excel shifts existing rows down to make room. A normal paste, by contrast, can replace destination contents.
Can I copy rows that are not adjacent?
You can try selecting separate row headers with Ctrl-click on Windows, but Excel does not reliably paste multiple separate areas as one block. Copy and paste each row or continuous block separately for a predictable result.
Will copying rows also copy formulas and formatting?
Yes, a standard copy of rows or cells transfers formulas and formatting as well as values. Relative formula references may adjust to the destination. Choose Paste Special if you want values or another specific type of content instead.
Can I copy rows to another worksheet or workbook?
Yes. Copy the rows, switch to the destination worksheet or open workbook, select the destination, and paste. Check column alignment and formulas, especially if the two sheets use different layouts.
How do I undo a row copy or paste?
Press Ctrl+Z on Windows or Command+Z on Mac soon after the action. Undo reverses the paste; it does not remove the original rows because copying leaves them in place. If later edits have been made, check the workbook before undoing multiple actions.
Related
- How to Combine Columns in Excel Without Losing Data
- How to Combine CSV Files in Excel with Power Query
- How to Color Values in Excel with Conditional Formatting
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Get Data From a Semantic Model: Connect and AnalyzeYes. In Excel for Microsoft 365 on Windows, connect to a Power BI semantic model through Data >…
- Excel Time Table: Create a Clear, Working ScheduleAn Excel time table is a worksheet that lays out activities against days and times. To make one,…
- Align Excel Columns: Shortcuts for Text and Column WidthIn Excel for Microsoft 365 on Windows, select the cells and press Alt, H, A, then C to…
- How to Change Track Changes Color in Microsoft WordTo change the color used for tracked edits in Word for Microsoft 365 on Windows, open Review, open…
- What Is Power Query? Excel Data Cleanup ExplainedPower Query is Microsoft Excel’s data-import and transformation tool: it connects to files, databases, and other sources, then…
- Excel Dependent Drop-Down Lists: Setup and FixesYes. In Excel for Microsoft 365 on Windows, create a drop-down for the first choice, then make the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.