See all How-To Articles

How to Duplicate Rows in Excel & Google Sheets

In this tutorial, you how to duplicate rows in Excel and Google Sheets.

 

duplicate rows initial data

 

Duplicate Rows – Copy and Paste

The easiest way to duplicate rows is to use Excel’s Copy and Paste functionality. Say you have the following data set and want to copy Row 7 to Row 8.

 

duplicate rows initial data

 

1. Select the row you want to copy by clicking on a row number (here, Row 7), then right-click anywhere in the selected area and choose Copy (or use the keyboard shortcut CTRL + C).

 

duplicate rows copy paste

 

2. Right-click the row number where you want to paste the copied row, and click Paste (or use the keyboard shortcut CTRL + V).

 

duplicate rows copy paste 2

 

As a result, the entire Row 7 is copied to Row 8.

 

duplicate rows copy paste 3

 

To use copy and paste to duplicate a whole row within a macro, see VBA Copy / Paste Rows & Columns.

Copy a Row to Multiple Rows

You can also copy one row and paste it into multiple rows. For example, follow these steps to copy Row 7 to Rows 8–10:

1. Select the row you want to copy by clicking on a row number (Row 7). Then right-click anywhere in the selected area, and choose Copy (or use the keyboard shortcut CTRL + C).

 

duplicate rows copy paste

 

2. Select the row numbers where you want to paste copied row, then right-click anywhere in the selected area, and choose Paste (or use the keyboard shortcut CTRL + V).

 

copy row to multiple rows

 

As a result, Row 7 is now copied to Rows 8–10.

 

copy row to multiple rows 2

 

Duplicate Rows With the Fill Handle

You can also duplicate rows using the fill handle.

1. Select the row you want to copy, and position the cursor in the left bottom corner of the selection range until the small black cross appears (the Fill Handle).

 

duplicate rows using fill handle

 

2. Then drag the cursor down to the next row (or to multiple rows, depending on the number of duplicates you want).

The result is exactly the same as demonstrated with the copy and paste method above.

 

duplicate rows copy paste 3

 

Duplicate Rows in Google Sheets

You can use any of the options above in exactly the same way in Google Sheets to duplicate rows.