How to Duplicate Rows in Google Sheets

Last Updated on October 30, 2023 by Jake Sheridan

In this tutorial, you will learn how to duplicate rows in Google Sheets.

How To Duplicate Rows in Google Sheets

There are many possible reasons why you might want to duplicate rows in Google Sheets.

For example, duplicating rows in a spreadsheet can be a great way to quickly populate data without having to manually enter it. You may also want to duplicate rows to apply the same formula or formatting to a whole range of cells.

Google Sheets provides several methods to duplicate rows in Google Sheets

This guide will explain some methods you can use to create a copy of a row in Google Sheets.

How To Add a Copy of a Row in Google Sheets

Here’s how to add a copy of a row in Google Sheets.

Step 1

First, select the row you want to duplicate. You can quickly select an entire row by clicking on the row header number found on the left-hand side of the spreadsheet.

In this particular example, we want to create a duplicate of row 6 in our spreadsheet.

Step 2

Use the keyboard shortcut Ctrl+C to copy the currently-selected row.

Step 3

Select a new row where you want to add a copy of the row you want to duplicate.

In this example, we want to place a copy of row 6 in row 21.

Step 4

Use the keyboard shortcut Ctrl+V to paste the duplicate row into the selected row.

Step 5

We can use similar steps to duplicate two or more rows in a spreadsheet.

Step 6

Use the Ctrl+C and Ctrl+V keyboard shortcuts to copy and paste multiple rows to create duplicates.

Step 7

We can also use the Fill Handle feature to duplicate rows in Google Sheets.

First, select the cell you want to duplicate. Use your cursor to click and drag the blue square in the bottom-right cornet downward.

Step 8

Google Sheets will automatically duplicate the selected range as far as you drag the fill handle.

Summary

This guide should be everything you need to duplicate rows in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.