How to Copy a Sheet to Another Workbook in Google Sheets

If you’re a project manager, you know that keeping everyone on task is imperative. Suppose each member of your team creates reports with Google Sheets. Imagine the time it would take you to sift through endless spreadsheets to find something you need quickly. The time wasted could take your project over budget.

How to Copy a Sheet to Another Workbook in Google Sheets

However, there is a way to access all of the reports in one place by creating a secure master workbook to review reports and collaborate with your team. This article will show you how to copy a spreadsheet and place it into another one in Google Sheets.

How to Copy a Sheet to a New Spreadsheet on a PC

You can copy a sheet into a new spreadsheet on your PC in a few easy steps:

  1. Make sure the latest version of Google Sheets is installed on your PC.
  2. Open the Google spreadsheet you want to copy.
  3. Right-click on the sheet name at the bottom of the document.
  4. Select “Copy” from the menu.
  5. Select “New spreadsheet.”
  6. Tap “Open spreadsheet” in the pop-up window.
  7. Right-click on the new sheet and tap “Paste.”
  8. Rename and save the new spreadsheet.

For security reasons, some browsers will not allow you to copy and paste using the right-click option. Try one of the following options if you encounter this problem.

Use keyboard shortcuts as follows:

  1. Open the sheet you want to copy.
  2. Press the Ctrl + C keys to copy the document.
  3. Open a new sheet.
  4. Press the Ctrl + V keys to paste.
  5. Rename and save the sheet.

To use the “Edit” function from the menu (top right of the screen):

  1. Open the sheet you want to copy.
  2. Select “Copy” from the edit menu.
  3. Open a new spreadsheet.
  4. Select “Paste” from the edit menu.
  5. Rename and save the new spreadsheet.

Make sure you have extensions enabled to ensure the “Edit” function works in your browser. Here are the steps to enable the feature if you haven’t done so already:

  1. Open the menu on the top right side of the screen (3 vertical dots).
  2. Scroll down and tap “More tools” and then “Extensions.”
  3. Turn on the toggle switch for “Docs Offline Extensions.”

Keep in mind that you must install the Docs Offline Extension to use the edit menu option. You can download it from the Chrome web store if it is not in your browser. It can also be used to copy a Google Sheet to another workbook while you are offline. To do so, you must:

  • Be connected to the internet.
  • Use the Google Chrome browser.
  • Turn off private browsing.
  • Have enough space on your device to save your files.

Once you’ve confirmed you meet the requirements, follow the steps below to turn on offline access to Google Sheets:

  1. Download Google Drive.
  2. Use your Google Chrome login information to sign in to Google Drive.
  3. Click “Settings” (the gear icon) at the top right.
  4. Turn on the “Offline” setting.
  5. Open Google and work in your Chrome browser.

By default, you will have two sheets with the same formatting when you copy a sheet. However, you can change the formatting and other options on the new Google Sheet using Paste Special.

This feature is useful to copy and recycle customized reports or budgets, but it can utilize different formatting. Follow these steps to change the format from a PC using Paste Special:

  1. Open the spreadsheet you want to copy.
  2. Click “Edit” (top right of the screen).
  3. Right-click on the sheet name at the bottom of the document, select “Copy to” from the menu and select “New spreadsheet”.
  4. Choose “Open spreadsheet” in the pop-up window.
  5. Open the “Edit” menu again and tap “Paste Special.”
  6. Choose from options including:
    • “Paste values only” to paste just the text within the cells from the original sheet.
    • “Paste format only” to paste just the cell formatting from the original sheet.
    • “Paste column widths only” to resize the columns to match the original sheet.
    • “Paste all except borders” to copy the sheet into another workbook without borders.

There are several other options within the “Paste Special” menu on your PC. Use the Paste Special feature when you do not want the new workbook to be an exact copy of the original.

How to Copy a Sheet to a New Spreadsheet From the iPhone App

Just because you’re away from your computer doesn’t mean you need to sacrifice your productivity. Copy a Google Sheet to a new one in a handful of simple steps using the iPhone app.

If you haven’t already done so, download the Google Sheets app from the Apple Store. Here’s how to get started:

  1. Look for the Google Sheets app in the App Store.
  2. Tap “Get.”
  3. Select “Install.”

Once you’ve completed installation, Google Sheets will appear on your home screen. To copy a sheet to a new spreadsheet from your device, follow these steps:

  1. Open a Sheet file.
  2. Tap the “Down” arrow on the sheet tab.
  3. Tap “Duplicate.” An identical sheet named “Copy of Sheet” will appear in a new tab.
  4. Open the duplicate sheet. Rename and save the file.

Here’s how to copy a sheet to another spreadsheet offline from an iPhone:

  1. Open Google Sheets.
  2. Tap “Menu.” Go to “Settings.”
  3. Select “Make recent files available online.”

Any sheets you work on offline will now be saved and available to copy to another workbook. To find a saved sheet online:

  1. Open Google Sheets.
  2. Tap “Menu” (3 horizontal lines).
  3. Select “Offline” and choose your file.
  4. Copy the file and paste it into a different workbook.

Keep in mind that the Paste Special feature is not available on iPhones, but some users have found a lengthy workaround for this issue. Here are the steps:

  1. Copy the column or row in the original sheet.
  2. Open a new sheet and paste the values inside.

The original formula will not follow; only the values will appear in the new sheet. The numbers must be copied and pasted again.

How to Copy a Sheet to a New Spreadsheet From the Android App

Before you start copying new spreadsheets, you need to install the latest version of the Google Sheets for Android app. Find the app in the Google Play Store and install it on your device. Then do the following:

  1. Open a Google Sheets file on your Android phone or tablet.
  2. Tap and hold the worksheet.
  3. Select “Copy” in the menu that appears.
  4. Open a new spreadsheet.
  5. Tap and hold where you want to paste the sheet.
  6. Select “Paste” in the menu that appears.
  7. Name and save the new spreadsheet.

To use Paste Special to change the format in a new workbook you copied on the Android app:

  1. Highlight the cells you want to change on the original Sheet.
  2. Select “Copy.”
  3. Open a new Sheet.
  4. Tap and hold the area you want to paste.
  5. Select “Paste Special.”
  6. Choose “Paste Format Only” or any other option from the menu.

Here are the steps to copy and paste in Google Sheets from the Android app while you are offline:

  1. Open Google Sheets on your device.
  2. Tap “Menu” then “Settings.”
  3. Tap “Make recent files available online.”

Any sheets you work on will be saved when this setting is on. To find a saved sheet online:

  1. Open Google Sheets.
  2. Tap “Menu” (3 horizontal lines).
  3. Select “Offline” and choose your file.

21st Century Numbers Game

One project or business can involve thousands of people located around the globe, and that can be a logistical nightmare. Thankfully, Google Sheets makes managing complex work projects simple. The tool integrates and aligns everyone using the spreadsheets to ensure that everyone is on the same page.

Google Sheets is not just for corporations, however. The average user can use the app to create to-do lists, budgets and keep their personal organization goals on track.

Are spreadsheets essential in your technical arsenal? If so, share with us if they are helpful for business, personal use, or both. Tell us about it in the comments box below.

Leave a Reply

Your email address will not be published.


Disclaimer: Some pages on this site may include an affiliate link. This does not effect our editorial in any way.

Todays Highlights
How to See Google Search History
how to download photos from google photos