How to create a copy of a sheet on Google Sheets within the same or on another spreadsheet

Google Docs is undoubtedly one of the most useful programs and can make things easier at work. One thing we might need to do every day in Google Sheets or Microsoft Excel is to create a copy of an existing sheet within the same spreadsheet or on another one. This can be useful in multiple situations, and today I will talk about how you can do that, on Google Sheets. 

You can alternatively copy all the content within the sheet and paste it on a new one, but that can lead to several problems with formatting, column width, etc. if you are not doing it correctly. So, creating the copy of an existing sheet is by far the best solution, and I will discus, how you can do that, today, on InkedFreedom.

So, without any further delay, let’s get started with how you can copy a sheet on Google Docs.

How to create a copy of a sheet on Google Docs?

Open the preferred document on Google Sheets, and tap on the small drop-down menu, just beside the name of the sheet, and click on ‘Duplicate’.

A copy of the selected sheet will be created right after that. Now, you will have to rename the sheet to something that is more relevant. Click on the drop-down menu again beside the name of the copied sheet, and click ‘Rename’

Now, type in the new name, and hit the enter key. It is done.

How to create a copy of a sheet on another document on Google Sheets?

With the power of the cloud on Google Sheets, you can also create a copy of the selected sheet to another spreadsheet document on your Google Drive account. To do that, just click on the drop-down menu beside the name of the sheet, and select ‘Copy to’, followed by ‘Existing spreadsheet’.

Alternatively, you can also create a new spreadsheet and copy the sheet to that new spreadsheet if you want. Just use the ‘New spreadsheet’ option instead, under the ‘Copy to’ option.

Now, you simply have to choose the Google Sheets document, where you want to have a copy of the currently selected sheet, and click on ‘Select’.

Now, a confirmation message will be displayed. You can either, open the other spreadsheet directly, or click on ‘OK’.

So, that’s how you can create a copy of a sheet on Google Docs, whether in the current or to an existing document. This can be useful in several situations, and you can not just save some precious time doing this, instead of copying the content and formatting to another sheet.

So, that was all about how you can create a copy of an existing sheet within the current or an existing or new spreadsheet.

Do you have any questions? Feel free to comment on the same below.