Copy Sheet(s) From One Google Drive Sheet or Gsheet To Another

by Rohit Khurana on July 14, 2012

Advertisement

Yesterday we shared with you a small tip to add conditional formatting to Google Drive Sheet or Gsheet which is a small but very useful tip. In continuation to share some tips on Google Docs, in this article I share another useful tip for copying an entire Google Drive sheet or Gsheet across a another Gsheet file. Before I jump into details, lets talk about how it is helpful and why would someone need to do this when he/she can simply copy-paste entire text from one sheet to another?

Like conditional formatting, formulas, height and width of cells there are numerous changes which one usually does to make the sheet easy to read and understand. When you copy paste data from one Gsheet to another, these elements and customizations are not fully copied from one sheet to another. Say for an example you have created a sheet to track some orders in your organization and now you want to share the same format to track more orders or you want your colleague from other department to share the same format with same features and design, you will find this small tutorial very handy. There are many other scenarios where you will find this tip very helpful. Now that we know how it it useful, lets see how it is done.

How To Copy A Sheet From One Gsheet To Another?

Gsheet is the file which can contain multiple sheets. These sheets can be copied to another sheet which you have created or which you have write access to (a sheet shared with you by someone else). If you need to copy multiple sheets, you need to follow this process one by one for individual sheets you want to copy.

First things first, you need a destination sheet and a source sheet. The destination sheet is the sheet where you want to copy, now that destination sheet maybe created by you or maybe created by someone and shred with you for editing. If you want to create it yourself and then share it with others, simply click on create option on Google Drive page and select Spreadsheet.

Copy Sheets Across Gsheets or Google Drive Sheets (5)

For this demonstration I have created a new sheet which I call “New Result Sheet For Demo”. My source sheet is the “Conditional Formatting Demo Sheet” which I created for my earlier tutorial. Before you copy it to other sheets, you may want to rename the Sheet for easy identification in your destination sheet. This is especially helpful when you have many sheets inside one file. To rename a sheet, simply click on the small arrow in form of the sheet name and select Rename option.

Advertisement

rename sheet

After you have given it desired name (optional), you need to click on the same arrow and select the option “Copy to…”

Copy Sheets Across Gsheets or Google Drive Sheets (1)

This will show all the sheets in your google drive account on which you have write permission. You can select the destination sheet(s) where you want to copy the source sheet. You can copy the source sheet to more than one sheets at the same time as well. Simply tick the sheet(s) where you want to copy and click on the blue coloured select button.

Copy Sheets Across Gsheets or Google Drive Sheets (2)

It will take a few moments and will show you a success message like this if all goes smooth.

Copy Sheets Across Gsheets or Google Drive Sheets (3)

Now you simply need to open the destination sheet to verify the copying and this is it.

Copy Sheets Across Gsheets or Google Drive Sheets (4)

In destination sheet, it will be named as “Copy of” the original source sheet name so that you can easily locate and identify the same. I hope you will find this tutorial easy to follow. Do check out some more tips and tricks by Trouble Fixers.

If you like this article or this article helped you, you can +1 to recommend this article on google plus.

You can follow us on Twitter or join our Facebook Fan Page. If you have a question to ask us, submit your question at Answers By Trouble Fixers.

Looking for something else? Search here :

{ 2 comments… read them below or add one }

bala July 15, 2012 at 10:40 pm

Great guide. Enjoy reading your articles. Google docs loading a bit slow for me so using Zoho but not as feature rich as Gdocs.

Matthew January 31, 2013 at 6:42 am

“You can copy the source sheet to more than one sheets at the same time as well. Simply tick the sheet(s) where you want to copy and click on the blue coloured select button.”

How does one select multiple sheets? I am unable to do so and have tried all the key combos (ctrl, shift, alt, etc) plus a mouse click that I can think of in order to select multiple documents.

Leave a Comment

Previous post:

Next post:

© TroubleFixers – All about fixing computer troubles2007-2016 . All Rights Reserved.