In this tutorial, you will learn how to copy a row in Google Sheets.
How To Copy A Row In Google Sheets
Sometimes you may find yourself needing to copy a row in Google Sheets. This can be helpful if you want to quickly duplicate data, or if you need to move a row to a different location in your spreadsheet.
In this guide, we will explain how to quickly copy a row in Google Sheets using keyboard shortcuts, the Edit menu, and the Autofill feature.
How To Duplicate A Row In Google Sheets
Here’s how to duplicate a row in Google Sheets.
Select the row you want to copy. You can select an entire row by clicking on the row number header found on the left side of your spreadsheet.
In this example, we want to duplicate the sixth row in our current sheet.
Next, select the option Edit > Copy to copy the selected row. You may also use the keyboard shortcut Ctrl+C to copy the selection.
Select a new cell where you would like to paste the row. In this example, we want to paste the values into row 17.
Paste the copied row by selecting Edit > Paste or by using the Ctrl+V keyboard shortcut.
The copied data should now appear in the new location.
Do note that pasting data this way will overwrite any existing data in the destination range.
Another way to copy a row is through the Autofill feature. Select the row you want to copy and drag the blue fill handle downwards.
Google Sheets will automatically add one or more copies of your target row, depending on how many rows down you’ve dragged your cursor.
Do note that this method may actually increment some values as seen above. To ensure that values do not increment, we suggest using the first method to create two identical rows. Select both rows and use the autofill feature to add additional copies of the row.
This guide should be everything you need to copy a row in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.