We’re going to do something fairly simple today—we’re going to copy a row into another sheet in Google Sheets.
Copying a row is something that you might do if you entered information into the wrong section of a sheet — or if you just needed to duplicate information between sheets.
Luckily, for such a common task, there’s multiple ways that you can accomplish it.
How to Copy Row to Another Sheet in Google Sheets
Let’s start with a simple list. In this example, we’re a camp counselor. We have a list of three campers that we had for our Fall 2020 semester. We want to be able to copy “Mary” into our Spring 2021 semester because we know that she’s going to be coming back.
Using CTRL+C and CTRL+V
Here’s the easiest, most direct way to copy the information over:
Select the information, press “CTRL+C” on your screen.
Go to where you want that information and press “CTRL+V.”
This is actually the way that you copy any information from one place in Google Sheets to another.
CTRL+C and CTRL+V are just short-hand for “copy” and “paste” on your computer. You can use this in Google Docs, Google Sheets, and pretty much everything else.
But there’s something important you should know.
Let’s say we already had data in row 1 — a brand-new camper named David. If we wanted to copy-paste Mary onto the top of the list, and we tried to do so, we would overwrite David entirely.
To do this properly (if we wanted Mary at the top), we would have to first insert a row above David.
Then we would be able to copy-paste Mary to the row above David. And we can always copy-paste Mary below.
Right-Click and Copy
There’s another way that we can do this and it’s actually (while a little more cumbersome) the appropriate way.
We go to Mary’s row and right-click.
Then we select “Copy.”
The reason this is the “right” way is that it automatically selects the entire row. Before, we were manually selecting the data.
Now we can right-click on the row again and select “Paste.”
Note that we can also “Paste Special.”
When we paste special, we can paste just the text, while ignoring the formatting. We can also choose to paste just the formatting (it’s a fast, easy way to copy over styles).
Using the Edit Menu
Finally, if you ever forget any of that, you should be aware that the copy and paste functions are also available through the Edit menu.
The edit menu gives you access to Cut, Copy, and Paste.
Undoing Your Copy and Paste
Every once in a while, you might make a mistake when you copy and paste. The most common type of mistake is overwriting other data.
Let’s say you copy two rows and you try to paste it into one. Rather than moving everything down, it’s going to overwrite two entire rows.
The easiest way to undo this is just to press the “Undo” button in Google Sheets. You can undo any action this way.
How to Cut and Paste Multiple Rows
What if Mary wasn’t supposed to have been entered into Fall 2020 at all but instead Spring 2021?
If that’s the case, we can instead “Cut and Paste.”
We cut the row that we want to remove.
And after we’ve pasted that into the Spring 2021 sheet it will be gone.
Now we can delete the row that is left behind.
How to Copy and Paste Multiple Rows in Google Sheets
You can copy and paste multiple rows in Google Sheets using the CTRL+C and CTRL+V feature outlined above. You would simply select multiple rows when you’re copying and pasting. Just make sure that you have enough space.
That’s it! Copying a row to another sheet in Google Sheets is quite simple and easy. Hope this helped!