How to Copy Multiple Rows in Google Sheets

This article is going to show you how to copy more than one row in Google Sheets so that you can paste it into a different spot in your spreadsheet, or copy it to another spreadsheet.

  1. Sign into Google Drive and open your Google Sheets file.
  2. Click and hold on the row number of the first row to copy, then drag to select the rest.
  3. Right-click on one of the selected rows and select the Copy option.
  4. Right-click in the cell where you want to paste the first row of copied data, then choose Paste.

You may already be familiar with copying and pasting a single cell of data in Google Sheets, but what if you need to copy a lot of data so that you can paste it into a different location?

Luckily the process for doing this is very similar to the process for copying a single cell, and it’s even possible for you to copy multiple rows of data in a Google Sheets spreadsheet.

Our tutorial below is going to show you how to copy multiple rows of data in a Google Sheets spreadsheet and paste it into a different Google Sheets spreadsheet.

How to Copy and Paste Multiple Rows in Google Sheets

The steps in this article were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or Edge.

Step 1: Sign into your Google Drive at https://drive.google.com and choose the Google Sheets file containing the rows to copy. If you’re pasting your data into a different file, you may also want to open that file now, too.

Step 2: Click and hold on the top row number to copy, then drag your mouse down to select the rest of the cells.

select the rows to copy

Step 3: Right-click on one of the selected rows, then choose the Copy option.

how to copy multiple rows in Google Sheets

Step 4: Right-click in the cell where you wish to paste the top-left cell of copied data, then choose the Paste option.

how to paste multiple rows in Google Sheets

Rather than right-clicking to use the Copy and Paste options, you can use keyboard shortcuts instead.

Keyboard shortcut for Copy in Google Sheets – Ctrl + C

Keyboard shortcut for Paste in Google Sheets – Ctrl + V

If you don’t want to copy a bunch of consecutive rows, but rather copy some rows that aren’t near one another, you need to use a different method. Click on the first row number you want to copy, then hold down the Ctrl key on your keyboard and click each other row you want to copy.

You can then right-click one of the selected rows and choose the Copy option, or press Ctrl + C to copy them.

Note that using this method will paste the copied rows consecutively into the chosen location. The Paste function won’t preserve the separation between the rows.

Find out how to insert a row in Google Sheets if you need to add some data in between existing rows of your spreadsheet.