The fastest way to copy a row

To copy a row in Excel, click the row number on the left side to select the entire row, then press Ctrl+C (Windows) or Command+C (Mac). Click where you want to paste it and press Ctrl+V or Command+V. The row pastes with all its content, formatting, and formulas intact.

If you only need to copy part of a row — say, columns A through D — click on cell A1, drag to D1, then copy and paste as usual. Excel will paste only what you selected, starting from wherever your cursor is positioned.

You can also right-click a selected row and choose Copy from the menu, then right-click where you want to paste and choose Paste. This method works the same way as the keyboard shortcut but takes more clicks.

Key Takeaways

  • Click the row number on the left to select an entire row, then use Ctrl+C to copy and Ctrl+V to paste.
  • To copy only part of a row, click and drag across the cells you need instead of clicking the row number.
  • Copied rows paste with their original formatting, colors, and any formulas they contain.
  • You can paste a copied row multiple times without copying again — the content stays in your clipboard until you copy something else.
  • Right-click menus work the same way as keyboard shortcuts but require more steps.

Copying rows with formulas

When you copy a row that contains formulas, Excel automatically adjusts the cell references in those formulas. If row 2 has a formula that adds B2+C2, and you copy it to row 5, the formula becomes B5+C5. This is usually what you want — it saves you from retyping the formula for each row.

If you want the formula to stay exactly the same (pointing to the original cells), you need to use absolute references. In the formula bar, change B2+C2 to $B$2+$C$2. The dollar signs lock those cells, so the formula points to B2 and C2 no matter where you paste it. This is less common but essential when you're copying a row that calculates something based on a single reference row.

Pasting without formatting

Sometimes you want to copy a row's data but not its colors, fonts, or borders. After you copy, right-click where you want to paste and choose Paste Special. A dialog box opens with several options.

Click Values to paste only the numbers and text, leaving formatting behind. Click Formulas to paste only the formulas without any colors or fonts. You can also paste just the formatting by choosing Formats, which is useful if you want to explore one row's appearance to another row's data.

On a Mac, Paste Special appears in the Edit menu. On Windows, you can also press Ctrl+Shift+V to open it directly without right-clicking.

Copying multiple rows at once

To copy several rows together, click the first row number, then hold Shift and click the last row number you want. All rows between them highlight in blue. Press Ctrl+C to copy them all, then click where you want them to start and paste.

If the rows you need aren't next to each other, hold Ctrl (Windows) or Command (Mac) and click each row number individually. They all highlight, and you can copy and paste them as a group. When you paste, they appear in the same order you selected them, starting from your cursor position.

Moving a row instead of copying it

If you want to move a row rather than copy it, select the row and press Ctrl+X (Windows) or Command+X (Mac) instead of Ctrl+C. This cuts the row. Then click where you want it and paste. The row disappears from its original location and appears in the new one.

Be careful with cut and paste — if you click somewhere else before pasting, the cut operation cancels and your row stays where it was. Copy is safer if you're unsure, since the original stays in place until you delete it yourself.

Common mistakes when copying rows

The most common error is selecting only the cells you can see instead of the entire row. If your spreadsheet has 50 columns but you only see 10 on screen, clicking and dragging across the visible cells leaves the hidden ones behind. Always click the row number itself to grab everything.

Another mistake is pasting over data you meant to keep. Excel doesn't warn you — it just overwrites whatever was there. If you're not sure, paste into an empty area first, check that it looks right, then cut and move it to the final location.

Formulas can also surprise you if you don't expect them to adjust. If a row has a formula that should stay the same everywhere, add dollar signs to lock the cell references before you copy. Test it in one location first to make sure it behaves the way you want.

Frequently Asked Questions

Can I copy a row from one Excel file to another?

Yes. Open both files, copy the row from the first file the same way you normally would, then switch to the second file and paste. Excel doesn't care whether the files are the same or different — it just pastes what's in your clipboard.

What happens to the row number when I paste?

The row number stays the same. If you paste into row 10, the data goes into row 10 and keeps that number. The original row keeps its original number. If you want to insert a new row instead of overwriting an existing one, right-click the row where you want the new data to start and choose Insert Copied Cells.

How do I copy a row and shift everything down?

Right-click the row number where you want the new row to appear and choose Insert Copied Cells. This pushes the existing rows down instead of overwriting them. If you use regular paste, it overwrites whatever was there.

Can I undo a paste if I made a mistake?

Yes. Press Ctrl+Z (Windows) or Command+Z (Mac) when ready after pasting. Excel undoes the last action. You can undo multiple times to go back several steps if needed.