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.
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.
After you have given it desired name (optional), you need to click on the same arrow and select the option “Copy to…”
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.
It will take a few moments and will show you a success message like this if all goes smooth.
Now you simply need to open the destination sheet to verify the copying and this is it.
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.