In this tutorial, you will learn how to copy and paste multiple rows in Google Sheets
How To Copy And Paste Multiple Rows In Google Sheets
You might find yourself in a situation where you might need to copy and paste multiple rows of data in Google Sheets. For example, you may have a list of data in one sheet that you want to copy to another sheet.
Or, you may want to make a duplicate of an existing row of data. Whatever the reason, there are a few different ways you can copy and paste multiple rows in Google Sheets.
In this guide, we will show you how to copy and paste multiple rows in Google Sheets. We will also explain how to insert a certain number of rows between cells to prevent the pasted data from overwriting existing data.
How To Insert Multiple Rows In Google Sheets
Here’s how to insert multiple rows in Google Sheets.
Step 1
First, we must select the first row of our range. Click on the row number heading on the left side of the spreadsheet to select the entire row automatically.
In this example, we’ll start by selecting row 2 of our sheet.
Step 2
Next, hit the Shift key and click on the row heading of the last row of the desired range. This will enable the user to select all the rows in between these two rows.
Step 3
Type the keyboard shortcut Ctrl + C to copy the selected rows.
Step 4
Select a new row which will be the destination of the copied data.
In this example, we want to copy and paste rows 2 through 4 to row 8.
Step 5
Paste the selected data using the keyboard shortcut Ctrl + V.
Step 6
Next, we’ll explain how to insert rows before pasting our data.
Start by copying the desired rows you want to insert in another part of the sheet.
Step 7
Next, select the rows that will hold your copied data.
In this example, we want to paste rows 15 to 17 into rows 21 to 23.
Step 8
Right-click on the selection. Click the option ‘Insert x rows above’ in the context menu.
Step 9
You should now have empty rows to place your desired data.
In our current example, we now have three empty rows that we’ll use to add a copy of rows 15, 16, and 17.
Step 10
Click on the first empty row and paste the data using the keyboard shortcut Ctrl + C.
Summary
This guide should be everything you need to copy and paste multiple rows in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.