To copy a line in Excel, select the row by clicking its number, press Ctrl+C, click the number of the destination row, and press Ctrl+V. To copy only part of a row, select the cells you want instead. Copying this way duplicates the selected contents and formatting while leaving the original in place.
This guide covers Excel for Microsoft 365 on Windows. In Excel for Mac, use Command+C and Command+V in place of Ctrl+C and Ctrl+V. Excel for the web has the same basic row-selection and copy-and-paste approach, though some shortcuts may be affected by your browser.
What You’ll Need
- An Excel workbook with the row or cells you want to duplicate.
- A destination row or range with enough room for the copied content. If the destination already contains information, decide whether replacing it is acceptable before pasting.
Step-by-Step
- Open the worksheet and identify what you mean by a line. In Excel, a horizontal line of worksheet data is usually called a row. Decide whether you want to copy the entire worksheet row, including empty cells across the sheet, or only a group of adjacent cells such as A4:F4. Copying just the data range is often safer if the sheet contains other information farther across the row.
- Select a whole row when that is what you need. Click the row number at the far left of the worksheet, such as the number 4. The entire row should become highlighted. You can select multiple adjacent rows by clicking the first row number and dragging over the others, or by holding Shift while clicking the last row number. To select nonadjacent rows, hold Ctrl on Windows while clicking their row numbers; on Mac, hold Command.
- Copy the selected row. Press Ctrl+C on Windows, or Command+C on Mac. Excel displays a moving dashed outline around the copied selection. You can also use Home > Copy on the ribbon or right-click the selected row and choose Copy. Do not choose Cut: Cut moves the data and removes it from its original location.
- Choose the destination. For a full-row copy, click the row number where the duplicate should go. If you choose a row that already has content, pasting will replace the cells in that row; check the destination first. To put the duplicate between existing records without overwriting them, right-click the destination row number and choose Insert Copied Cells. This inserts a new row and shifts existing rows downward.
- Paste the copied row. Press Ctrl+V on Windows or Command+V on Mac. Alternatively, use Home > Paste or right-click the destination and choose Paste. The copied contents and formatting are placed at the destination, and the original row remains unchanged. Click another cell or press Esc when you are finished to clear the moving outline.
- Copy only part of a row when appropriate. Click and drag across the cells you want, for example A4:F4, rather than clicking the row number. Copy, select the top-left cell of the destination range, and paste. Excel fills the same number of cells across from that starting point. Make sure the destination area is clear if you do not want existing entries replaced.
- Review the result. Check that the duplicate is in the intended location and that values, formulas, and formatting look right. If the copied cells contain formulas, Excel normally adjusts relative cell references to match the new position. Compare an important formula with the original before relying on it.
Common Mistakes
Selecting a cell instead of the row number: Clicking a cell selects only that cell. If you meant to duplicate the entire row, click the numbered heading at the left. Conversely, selecting the row number can copy far more than intended. If only a few fields belong in the duplicate, select those cells instead.
Pasting over useful data: Pasting into a row that already contains entries replaces the corresponding cells. If you want to make room, use Insert Copied Cells from the row-heading context menu rather than ordinary Paste. If you paste over something by accident, press Ctrl+Z on Windows or Command+Z on Mac immediately to undo it.
Using Cut instead of Copy: Cut relocates the selected content when you paste; Copy leaves the source in place. Confirm that you used Copy if both the original and duplicate should remain.
Assuming formulas become fixed values: A copied formula is still a formula, and its relative references may change. For example, a formula that refers to the cell immediately above may refer to the new row’s cell above after copying. Check formulas, especially when duplicating totals or calculations.
Copying into a filtered list without checking the selection: A filtered worksheet can make the visible rows appear to be the whole list, while hidden rows remain in the sheet. Check what is selected and where the pasted row will land. If the list is important, consider copying into a clearly identified blank row and reviewing the result before saving.
Tips
- Use the keyboard for a quick full-row copy. Click a cell in the source row, press Shift+Space to select the row, then Ctrl+C, select the destination row, and press Ctrl+V. On Mac, Shift+Space also selects a row in Excel; use Command+C and Command+V to copy and paste. If the shortcut selects a different range, click a normal worksheet cell first and try again.
- Use Insert Copied Cells to preserve existing records. Copy the source row, right-click the row number where it should appear, and choose Insert Copied Cells. This is useful in a list where inserting a duplicate is preferable to replacing the record currently at that position.
- Choose Paste Special when you do not want everything. After copying, right-click the destination and choose Paste Special to select an available paste type, such as Values or Formulas. The options can vary by Excel version and selection. Values are helpful when you want the displayed results without carrying over the source formulas; check formatting separately if appearance matters.
- Use a clear destination range for partial-row copies. When copying A4:F4, select the top-left destination cell, not an entire row, unless you intend to paste a full row. A matching six-cell space makes it easier to see what will be replaced.
- Check references and formatting before repeating the action. If the first duplicate looks correct, you can repeat the copy-and-paste for another destination. Verify each location, especially if formulas refer to other rows or the sheet uses special number formats.
Troubleshooting
Nothing appears after pasting: Make sure the copy outline is still visible and that you clicked a cell or row heading on the worksheet, not a ribbon control or another application. Copy the source again, then paste. If Excel is in cell-edit mode with a cursor inside a cell, press Esc to leave editing mode and retry.
The wrong cells were copied: Press Esc, click the correct row number or drag across the intended cells, and copy again. A highlighted cell is not the same as a highlighted row. If you selected a whole row but only wanted a few columns, select the precise cell range instead.
The paste replaced information: Immediately use Undo (Ctrl+Z on Windows or Command+Z on Mac). Then copy the source again and insert copied cells at the intended position, or choose an empty destination. Undo may not be available after closing the workbook or performing other actions, so check the destination before pasting.
Formulas show different answers: Click a copied formula cell and inspect the formula bar. Relative references usually adjust when copied, which may be correct. If a reference must stay pointed at the same cell, edit the formula to use an absolute reference with dollar signs before copying, or use Paste Special > Values if you only need the calculated result. Confirm the intended behavior before changing a sheet used for reporting.
Excel will not let you insert or paste: Check whether the worksheet is protected, the workbook is shared in a restricted way, or the destination is part of a merged-cell range or Excel table. Protection can block edits; ask the workbook owner to unprotect it if you are authorized. Merged cells and table layouts can limit where a full-row paste fits. Try copying only the intended cells or use a blank area to determine whether the destination is the problem.
Frequently Asked Questions
How do I copy a row in Excel without deleting the original?
Use Copy, not Cut. Select the row number, press Ctrl+C on Windows or Command+C on Mac, then select the destination and paste. The source stays in place.
How do I duplicate a row and insert it between two rows?
Copy the source row by clicking its number and pressing Ctrl+C. Right-click the row number where the duplicate should be inserted and select Insert Copied Cells. Existing rows move down to make space.
Can I copy only one line of cells instead of the entire worksheet row?
Yes. Select the required cells by dragging across them, such as B6:G6, then copy and paste starting at the top-left destination cell. This avoids copying unrelated cells elsewhere on the row.
Will copied formulas update in the new row?
Usually, yes. Excel adjusts relative references according to the new location. Absolute references marked with dollar signs remain fixed. Review formulas in the pasted row to make sure the change is what you intended.
Can I copy a row in Excel for the web?
Yes. Click the row number to select the row, use the Copy command or Ctrl+C, select the destination row, and paste. In a browser, a shortcut can sometimes be intercepted, so use the Home ribbon or right-click menu if it does not work.
Related
- Convert an Excel File to a Google Doc: Step by Step
- Convert Excel to Word: A Step-by-Step Guide
- Convert an Excel Cell to Number: Quick Methods
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Find Duplicates in Google Sheets: A Step-by-Step GuideTo find duplicate values in Google Sheets, select the cells you want to check, choose Format > Conditional…
- Google Sheets COUNTIF With Multiple Criteria ExplainedGoogle Sheets’ COUNTIF function accepts one condition; to count cells that meet multiple conditions at the same time,…
- Create a Vertical Line in an Outlook Email SignatureTo create a vertical line in an Outlook signature, use a two-column table and show only the border…
- Excel Cell Merge Shortcut Keys and How to Use ThemIn Excel for Microsoft 365 on Windows, select the cells and press Alt+H, M, then C to use…
- CSV vs Excel Sheet: Key Differences and When to Use EachA CSV is a plain-text file for storing rows and columns of data; an Excel workbook can hold…
- Excel Data Entry: Enter and Manage Cell ValuesTo enter a value in Excel, select a cell, type a number, text, date, or formula, and press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.