How to Duplicate a Google Sheet: Quick & Easy Guide

I am a fan of creating to-do lists and trackers. And Google Sheets is my weapon of choice.

Since I have created a lot of these lists and trackers, I decided to merge all my trackers into one single Google Sheets document and then use this master tracker instead.

And to do this, I had to copy sheets from multiple Google Sheets into one single Google Sheets document. However, I did not know how to duplicate a Google Sheet.

While it’s not complicated, it took me a few minutes to figure it out.

So I thought I would share with you how to copy sheets in Google Sheets.

How to Duplicate a Sheet in Google Sheets

Here’s how to duplicate Google Sheets tabs:

Step 1: Right-click on the sheet you want to duplicate or click the down arrow on the sheet tab

Step 2: Select Duplicate from the menu.

The new Google Sheets duplicate will automatically show in the tray as “Copy of Sheet X” If you don’t need to copy your data into a completely new file, this is how to duplicate a Google spreadsheet most easily.

How to Duplicate a Google Sheet Into Another Google Sheet

Sometimes you might want to copy the data you have to a new or an existing spreadsheet. Instead of copying the rows you can also just copy the sheet. Below are the steps on how to copy a Google Sheet to another sheet:

Copy to a New Spreadsheet

1. Open the Google Sheets document from which you want to copy the sheet. So these would be different trackers (lists) that I want to combine.
2. Right-click on the sheet that you want to move to another master tracker Google Sheets document.

3. Click on ‘Copy to..’ option.
4. You will get 2 options: Copy to New spreadsheet and Existing spreadsheet. Click New spreadsheet.

5. Choose copy to a New spreadsheet. You will get the prompt below to show the sheet copied successfully.

6. Click Open spreadsheet to view the new spreadsheet with the duplicated sheet.

Copy to an Existing Spreadsheet

1. Right-click on the sheet that you want to move to another master tracker Google Sheets document.

2. Click on ‘Copy to..’ option.
3. You will get 2 options: Copy to New spreadsheet and Existing spreadsheet. Click Existing spreadsheet.

4. In the dialog box that opens, you need to select the Google Sheets where you want the sheet to be copied. This Google Sheets document could be in your own Google Drive or the one that is shared with you (with edit rights).
   

   

5. Once the Google Sheets in which you want to copy the sheets is selected, click on Select.

You will see a prompt that will tell you that the sheet has been copied. You can also open the target Google Sheets document, which now has the copied sheet.

Note that when the sheet is copied, it still remains in the source worksheet. A copy of the sheet is created in the target document.

In case you have the link to the Google Sheets in which you now know how to copy a Google Sheet to a sheet, you can simply enter the link at the bottom of the dialog box (step 4 above), and then click Select.

How to Rename the Duplicated Sheet.

Once you have duplicated a sheet in Google Sheets it is automatically named Copy of “Original Sheet Name”. You can change the sheet name by:

1. Left-click the duplicated Google Sheet tab
2. Select Rename
3. Type in the new name.

4. Hit Enter

How to Move a Sheet

If you are working with multiple sheets, you might want to rearrange them for convenience. Moving a sheet is a very simple process:

1. Right-click on the sheet tab you want to move and hold
2. Drag it to where you want to move it
3. Release the right mouse button to place the tab in the new position

Frequently Asked Questions

Can You Duplicate a Whole Google Sheet?

Yes, you can. In this article, we have shown you how to copy a spreadsheet in Google Sheets. All you need to do is right-click in the sheet tab for the sheet you want to duplicate and choose duplicate. This will create a new spreadsheet called Copy of “Original Sheet Name”.

How Do I Mass Duplicate a Sheet in Google Sheets?

There is currently no way to mass duplicate Google Sheets multiple sheets to a specific number all at once. An easy way to mass duplicate a sheet is by duplicating multiple existing copies of the sheet:

1. Create your first duplicate using the method shown in the article above.
2. Click the first sheet, hold down the CTRL key and click the second sheet. This is a cool spreadsheet trick to highlight Google Sheets multiple tabs simultaneously.
3. Next right click on the second sheet and choose Duplicate. You will get two more copies instead of one.

Can I Duplicate a Sheet Multiple Times in Google Sheets?

You can duplicate a sheet in Google Sheets as many times as you want. However, you will have to do it one by one. We’ve already shown you how to copy a tab in Google Sheets. You can also duplicate multiple Google Sheet tabs by creating a copy and then duplicating the original sheet tab and the copy simultaneously.

Final Thoughts

Whichever method you use, this process is fairly straightforward, and you should now know how to duplicate a Google Sheet.

Google Sheets Duplicate works well to copy an entire sheet with one click. while Copy to is great to assign where you need the copy.

Now that you know how to copy a sheet in Google Sheets, check out some of our other articles, like how to transpose data or how to compare two columns in Google Sheets.

Related:

• Creating a Heat Map in Google Sheets (Step-by-Step Tutorial).
• How to Color Alternate Rows in Google Sheets.
• How to Zoom In and Zoom Out in Google Sheets.
• How to Insert an Image in a Cell in Google Sheets.
• How to Compare Two Columns In Google Sheets
• Format Painter in Google Sheets (Copy formatting easily)