The result is exactly the same as demonstrated with the copy and paste method above. Then drag the cursor down to the next row (or to multiple rows, depending on the number of duplicates you want).

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

You can also duplicate rows using the fill handle.

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).Īs a result, Row 7 is now copied to Rows 8–10.

Then right-click anywhere in the selected area and choose Copy (or use the keyboard shortcut CTRL + C). Select the row you want to copy by clicking on a row number (Row 7).For example, follow these steps to copy Row 7 to Rows 8–10: You can also copy one row and paste it into multiple rows. To use copy and paste to duplicate a whole row within a macro, see VBA Copy / Paste Rows & Columns. Right-click the row number where you want to paste the copied row and click Paste (or use the keyboard shortcut CTRL + V).Īs a result, the entire Row 7 is copied to Row 8.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).Say you have the following data set and want to copy Row 7 to Row 8. If you’re starting with duplicate rows and want to remove them, see this page. The easiest way to copy rows exactly is to use Excel’s Copy and Paste functionality. This tutorial shows how to duplicate rows in Excel and Google Sheets.

How to add multiple rows in excel 16.24