How to Copy a Row From One Sheet to Another in Google Sheets: A Step-by-Step Guide

Copying a row from one sheet to another in Google Sheets is a handy skill to have, especially if you’re managing large sets of data. Whether it’s for streamlining workflow, creating backups, or compiling information, it’s a process that can save you loads of time. In this article, I’ll guide you through the easy steps to get this task done without breaking a sweat.

Step by Step Tutorial: How to Copy a Row From One Sheet to Another in Google Sheets

Before diving into the specifics, it’s important to understand that this process involves selecting the row you wish to copy, copying it, navigating to the destination sheet, and pasting the row in the desired location. Let’s break it down.

Step 1: Select the Row to be Copied

Click on the row number on the left-hand side of the sheet to highlight the entire row.

Selecting the entire row ensures that you copy all the data in that row, including any formulas or formatting that might be present. It’s crucial to click on the row number and not just drag your cursor across the cells, as this can sometimes miss hidden cells or data.

Step 2: Copy the Selected Row

With the row selected, right-click and choose ‘Copy’ from the context menu, or simply use the keyboard shortcut Ctrl+C (Cmd+C on Mac).

Copying the row is straightforward, but remember that if you have any special formatting or formulas, they will be copied along with the data. This means that when you paste the row into the new sheet, it will look and function exactly as it did in the original sheet.

Step 3: Navigate to the Destination Sheet

Open the sheet where you want to paste the copied row by clicking on its tab at the bottom of the window.

Navigating to the destination sheet is as simple as clicking on it. If the sheet is in a different Google Sheets file, you’ll need to open that file separately. It’s worth noting that you can also copy rows between different Google Sheets files using the same method.

Step 4: Select the Destination Row

Click on the row number where you want to insert the copied row in the destination sheet.

It’s important to select the entire row in the destination sheet to ensure that the copied data is pasted correctly. If you want to replace an existing row, simply paste over it. If you want to insert the copied row above or below a specific row, you will need to right-click on the row number and select ‘Insert 1 above’ or ‘Insert 1 below’ before pasting.

Step 5: Paste the Copied Row

Right-click on the selected row and choose ‘Paste’ from the context menu, or use the keyboard shortcut Ctrl+V (Cmd+V on Mac) to paste the copied row.

Pasting the row is the final step in the process. If you’ve selected ‘Insert 1 above’ or ‘Insert 1 below’ in the previous step, the new row will be pasted accordingly. Otherwise, the data will be pasted into the selected row, replacing any existing data.

After completing these steps, the row from the original sheet will be successfully copied to the destination sheet. This method ensures that all data, including formatting and formulas, are preserved and transferred accurately.

Tips for Copying Rows in Google Sheets

  • Always double-check that you’ve selected the entire row before copying to avoid leaving out any data.
  • Use keyboard shortcuts for copying (Ctrl+C) and pasting (Ctrl+V) to speed up the process.
  • If you need to copy multiple rows, you can select them by holding down the Shift key while clicking the row numbers.
  • When copying rows with formulas that reference other cells, ensure that the references remain correct in the new sheet.
  • If you’re copying a row to a sheet with different formatting, consider using ‘Paste special’ options to match the destination sheet’s format.

Frequently Asked Questions

How do you copy a row to another sheet in Google Sheets without overwriting existing data?

To avoid overwriting existing data, you can insert a new row in the destination sheet before pasting. Right-click on the row number where you want the new row to appear, and select ‘Insert 1 above’ or ‘Insert 1 below’ before pasting.

Can you copy a row from one Google Sheets file to another?

Yes, you can copy a row from one Google Sheets file to another by following the same steps outlined above. Just ensure you have both files open and navigate to the desired destination sheet in the other file.

Will copying a row also copy the row’s height and formatting?

Copying a row will copy the data, formulas, and formatting, including the row height. However, if you use ‘Paste special’ options, you can choose to paste only specific elements like values or formatting.

Is it possible to copy multiple rows at once?

Absolutely! You can copy multiple rows by holding down the Shift key and clicking on the row numbers of the first and last rows you want to copy. Then, follow the same copy and paste steps.

Can I undo a row copy if I make a mistake?

Yes, you can undo a copy or paste action by pressing Ctrl+Z (Cmd+Z on Mac) or by clicking the ‘Undo’ button in the Google Sheets toolbar.


  1. Select the row to be copied.
  2. Copy the selected row.
  3. Navigate to the destination sheet.
  4. Select the destination row.
  5. Paste the copied row.


Copying a row from one sheet to another in Google Sheets might seem like a small task, but it’s a fundamental skill that can significantly improve your productivity. Whether you’re a student juggling data for a project or a professional handling crucial spreadsheets, mastering this simple task can make your life a whole lot easier. Plus, with the tips and FAQs provided, you’ll be equipped to handle any curveballs that might come your way. And remember, practice makes perfect! So why not give it a try right now and see how smoothly you can transition that row to its new home?

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy