Spreadsheet users often find themselves on a treadmill of repetitive tasks.
A simple way any spreadsheet user can save time and energy is by making duplicates or copies of existing spreadsheets and using those after making necessary changes.
In this way, you get to keep the structure and format of the original sheet, while only changing a few things that need to be changed.
Making duplicates of a spreadsheet in google sheets is quite simple and easy. Moreover, there are multiple ways in which you can duplicate sheets.
In this tutorial, I will show you step by step process of how to duplicate a Google Sheets.
01. How to Duplicate a Google Sheets?
If you want to duplicate the sheet within the same document, here is the step-by-step process:-
- Go to Google Sheets tool and open the appropriate worksheet.
- Next, identify the specific sheet in your worksheet that you want to duplicate. You can see all the sheets within a worksheet at the bottom of the screen.
For example; I have two sales reports named “Sales Report January” and “Sales Report February.” I want to duplicate the January Sales Report.
- Once you are on the appropriate tab, right click on the tab name and choose “duplicate” option that appears in the pop-up list.
- After you click “duplicate”, a copy of the original sheet will appear to the right of the original sheet. The default title of any duplicate sheet will be “Copy of [original sheet name].” You can simply double click on the name and rename it to a relavnt one.
That’s it… You have successfully created duplicate of a Google Sheets.
02. How to Copy Google Sheets to another Sheet?
There can be times when you want to copy a Google sheet to another worksheet. This is where Google Sheet copy features come in handy. Here is how it works:
- Like the previous situation, you can go to Google Sheets and open the worksheet that holds the sheet you want to copy.
- Next, identify the sheets in your worksheet that you want to copy. Continuing with our above example; I will copy the “Sales Report January” sheet to an existing worksheet named “Business Sales.”
- Next, right-click on the sheet name at the bottom of the document and hover over the “Copy to” option from the menu.
- When you hover over the “copy to” option, you will be asked to choose between copying the sheet into an “existing spreadsheet” or a “new spreadsheet. Since we want to copy Google Sheets to another spreadsheet, we will choose “existing spreadsheet.”
- Now a new dialog box will open, you need to select the Google Sheets in which you want your sheet to be copied. This Google Sheets could be stored in your own Google Drive, or the one that is shared with you. Once you’ve selected the sheet, click on Select to proceed.
That’s it… You will see a prompt that will tell you that the sheet has been copied.
03. How to Copy Google Sheets to New Sheet?
There may be times when you want to copy a Google Sheets to a new spreadsheet rather than an existing worksheet. Here is how you can do this:
- With a Google Sheet open, right click on a sheet name at the bottom of the document and hover over “Copy to” option.
- Next, click on the ‘new spreadsheet‘ option.
- You will see a prompt that will tell you that you sheet has been sucessfully copied. You can click on “open spreadsheet” to view the copied sheet or click on “ok” to view it later.
04. How to Copy a Worksheet in Google Sheets?
What if your worksheet contains multiple sheets and you want to copy the whole worksheet rather than a single sheet inside that worksheet.
It’s pretty easy… Here’s how:
- Go to Google Sheets and open the worksheet that you want to copy.
- Click “File” (top left of the screen) and select “make a copy.”
- A new popup will appear asking you to name your copied sheet. Give it a relevant name and click on “Ok.”
05. Final Thought:
This was all about how to copy or duplicate a spreadsheet in google sheets. The method you’ll use will completely depend on your situation and needs.
“Duplicate” feature works well for copying a sheet in just one click while “Copy to” features give you control over where you want to copy a Google Sheets.
Liked our step-by-step tutorial on how to duplicate a Google Sheets? Check out our hub of Google Sheets tutorial that will help you get better at managing spreadsheets.