How to Duplicate Lines in Excel | Copy Rows Without the Fuss

Duplicating lines in Excel is safest with the Insert Copied Cells option, which shifts existing rows down instead of overwriting them — use Copy (Ctrl+C) then right-click the target row and choose Insert Copied Cells.

Knowing how to duplicate lines in Excel saves time on everything from budget sheets to scheduling templates, but the right method depends on one thing: whether you need to preserve or replace the data underneath. A quick Ctrl+V overwrites whatever sits in the target row. The Insert Copied Cells command pushes that row down and inserts the copy above it, keeping everything intact. Below are the methods that work across Excel 2016 through Microsoft 365, including bulk repetition tricks that handle hundreds of rows in seconds.

How Do You Duplicate Rows Without Overwriting Data?

The answer is Insert Copied Cells, and it works the same in every desktop version of Excel going back years. Select the row number (the whole row), press Ctrl+C, click the row number where you want the copy to land, then right-click and choose Insert Copied Cells. The original target row shifts down, and your copied row sits above it.

Step by step:

• Click the row number of the line you want to duplicate — the entire row highlights.
• Press Ctrl+C (or right-click and choose Copy).
• Click the row number of the destination — this is where the copy will be inserted.
• Right-click the destination row number and select Insert Copied Cells from the menu.

The destination row shifts down by one row, and the copied content appears above it. No data is lost.

This method works on Windows and Mac (use Cmd+C on Mac) but is not available in Excel for Web — web users must fall back to standard copy-paste and accept the overwrite.

Copy and Paste When Overwriting Is Fine

If the target row is empty or you intend to replace its contents, Ctrl+C followed by Ctrl+V is the fastest route. Select the source row, copy it, click the target row, and paste. The entire row — formatting, formulas, and values — replaces whatever was there. Use this when you are building a new section or overwriting old data, never when the target row contains information you need to keep.

Duplicating Rows in Bulk with the Fill Handle

When you need to repeat a single row or a small block of rows many times, the Fill Handle is the tool. Select the row or rows you want to duplicate, hover the cursor over the bottom-right corner of the selection until it turns into a black cross, then click and drag downward. Excel copies the pattern into every row you drag across.

This works well for repeating header blocks, date sequences, or fixed values. It does not work for duplicating rows with formulas that should reference different cells — the Fill Handle adjusts relative references automatically, which may or may not be what you want.

What’s the Fastest Way to Repeat a Pattern of Rows?

For large-scale repetition — say, duplicating a 3-row block 125 times — the Go To + Paste trick cuts the job to seconds. Copy the block of rows, press Ctrl+G to open the Go To dialog, enter a large range like A4:A6000, and press Ctrl+V. Excel fills every cell in that range with your copied block, repeating it end to end.

Key detail: If your block includes blank separator rows, include those blank rows in the selection you copy — otherwise the pattern will not space correctly. For example, if you are copying 3 data rows plus 5 blank rows as a repeating unit, select all 8 rows before copying.

Methods at a Glance

How to Find and Remove Duplicate Rows

Duplicating lines is useful by design, but sometimes you need to undo unintended duplicates. Excel’s built-in Remove Duplicates tool handles this in one step. Select the data range, go to the Data tab, and click Remove Duplicates (or press Alt+A+M). Choose which columns to evaluate — if you check all columns, Excel removes only fully identical rows. If you check one column, it keeps the first row for each unique value in that column and discards the rest.

To highlight duplicates before removing them, select the range, go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values (shortcut: Alt+H+L+H+D). This color-codes every duplicate cell so you can review before deleting.

On Excel 2021 and Microsoft 365, the UNIQUE function extracts a list of distinct rows dynamically. On Excel 2016 and 2019, you must use the manual Remove Duplicates tool or an IF formula with COUNTIF.

Feature Availability by Excel Version

If you rely on Insert Copied Cells or dynamic array functions, a Microsoft 365 subscription or Excel 2021 is required. The free web version covers basic copy-paste but lacks the safer insertion method.

Common Mistakes to Avoid

• Pasting without Insert Copied Cells — Ctrl+V overwrites the target row silently. Use Insert Copied Cells whenever the destination row has data you need.
• Wrong Go To range — when using Ctrl+G, make sure the range starts at the first empty cell below your source block, not at row 1. A4:A6000 works if your source is rows 1–3; A1:A6000 would overwrite your source.
• Omitting gap rows in pattern copies — if your repeating unit includes blank rows, select and copy those blank rows as part of the block, or the pattern will collapse.
• Using Fill Handle on formula-heavy rows — the Fill Handle adjusts relative cell references, which can produce wrong results if the formulas need fixed references.
• Removing duplicates without checking headers — the Remove Duplicates dialog includes a “My data has headers” checkbox. Leave it unchecked when the selection has no header row, or Excel treats the first row as a header and may remove it.

Final Checklist for Duplicating Rows in Excel

Choose the method that matches your situation and verify the result with a quick scan. For preserving data, Insert Copied Cells is the default. For speed on empty rows, Copy and Paste. For large patterns, Go To + Paste. And when duplicates become a problem rather than a tool, the Remove Duplicates button under the Data tab clears them in one click.