When you’re working on Google Sheets, you might sometimes need to make a copy of your sheet. You might want to copy the sheet into an existing sheet, a new sheet, or even to your current sheet. Google Sheets allows you to copy a sheet easily.
4 methods to copy a sheet in Google Sheets
- Using the Duplicate option
- Using the Existing spreadsheet option
- Using the New spreadsheet option
- Using the Make a copy option
Method 1: Using the Duplicate option
You can use this option to copy a sheet into the spreadsheet that you’re working on.
Step 1: Pick the sheet you want to copy.
From the sheet tabs at the bottom, identify the sheet you want to copy. The Duplicate option is used to copy a sheet into the same spreadsheet by creating another tab.
Step 2: Click Duplicate.
Right-click on the sheet to open a dropdown. Click on Duplicate to copy the sheet into your current sheet.
Step 3: Check if your sheet has been copied.
After you click Duplicate, the sheet should’ve been copied to your current sheet. You would see another tab named Copy of <your file name>.
Say the Marks sheet is copied using Duplicate, the copied sheet would appear on the tab named Copy of Marks.
Method 2: Using the Existing spreadsheet option
This is another method that Google Sheets provides to copy your sheet. Similar to the above method, it copies the sheet to an existing spreadsheet of your choice instead of the current sheet.
Step 1: Identity the sheet you want to copy.
Identify the sheet you want to copy from the sheet tabs at the bottom.
Step 2: Click on Existing spreadsheet.
Right-click on the sheet tab to open a dropdown. Click Copy to and then tap on Existing spreadsheet.
Step 3: Select a spreadsheet to copy.
Clicking the Existing spreadsheet will open a dialog box. Find a spreadsheet you want to copy. After you choose the sheet, click on Select.
Step 4: Check if your sheet has been copied.
Once it’s copied, you’ll see a dialog box stating that you’ve successfully copied the sheet.
You can click the green button that says OK to finish the process. If you want to open the sheet right away, click on Open spreadsheet.
Now, if you open the spreadsheet you copied this sheet into, you can see a tab named Copy of <your file name>.
Method 3: Using the New spreadsheet option
You can use this method to copy your sheet into a new spreadsheet.
Step 1: Identify the sheet you want to copy.
Identify the sheet you want to copy from the sheet tabs at the bottom.
Step 2: Click New spreadsheet.
Right-click on the sheet tab to open a dropdown. Click Copy to and then tap on New spreadsheet.
Step 3: Check if you’ve copied the sheet.
Once you click New spreadsheet, wait for a few seconds.
Once it’s copied, you’ll see a dialog box stating that you’ve successfully copied the sheet.
You can click the green OK button to close the message. Click Open spreadsheet to open the copied spreadsheet.
You can now see a new sheet with the data you’ve copied.
Method 4: Using the Copy option
If you want to copy an entire spreadsheet with all the sheets inside it, you can directly use the Copy option.
Step 1: Identify the sheet you want to copy.
Open your Google Drive and find the sheet you want to copy.
Step 2: Click Make a copy.
Once you’ve identified the sheet you want to copy, right-click to see a dropdown. Click Make a copy to copy the entire worksheet.
Step 3: Check if your sheet has been copied.
After clicking Make a copy, wait for a few seconds.
You can then find a copy of your sheet in your Google Drive named Copy of <your file name>
Wrapping up
You don’t have to worry anymore about how to make a copy of your spreadsheet while working on Google Sheets. You now have 4 different methods to copy a sheet at your disposal. Use the one that best suits your needs.