Arrow left
Back to product guides
Google Sheets Tips

How to Duplicate a Sheet in Google Sheets

In this article, you will learn how to copy a worksheet in Google Sheets.

How to duplicate a sheet in Google Sheets

If you want to copy a worksheet into a file do the following:

  1. Move your cursor to a tab of the sheet you want to copy.
  2. Right-click and choose “Duplicate”.
How to duplicate a sheet in Google Sheets

If you want to copy a worksheet to another file (new or existing one):

  1. Go to a tab of the sheet you want to duplicate.
  2. Right-click and choose “Copy to.”
  3. If you want to make a copy of the sheet in a new Google Sheet file, click “New spreadsheet”.
  4. If you need a copy of the sheet in another existing Google Sheet, click “Existing spreadsheet,” select a file to which you want to copy the sheet in a pop-up, and click “Select” at the bottom left in the pop-up window.
How to copy a sheet to a new or existing spreadsheet

How do I duplicate a sheet in Google Sheets multiple times?

Google Sheets does not have a function to create a specific number of copies of a sheet. So, if you want to create three copies of the sheet, you need to repeat the above steps three times. Or, after you make a copy of a sheet, you can choose the original and the copied ones, and duplicate them at a time. To copy multiple sheets simultaneously, click the first tab and left-click the second one while holding down the Ctrl key, and select “Duplicate” in a pop-up menu. This action gives you two more copied sheets.

What are other tips on tabs you should learn?

These three articles are helpful if you are a beginner and need to learn how to insert and remove a tab or move to a different worksheet in a file.

How to Add and Delete a New Tab in Google Sheets

How to Switch Tabs in Google Sheets

How to Move Tabs in Google Sheets

The following three articles are beneficial when you have many worksheets in a file and want to make them neat or highlight specific tabs.

How to Rename a Sheet in Google Sheets

How to Hide a Tab in Google Sheets

How to Change Tab Color in Google Sheets

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.

Automate any custom financial dashboard in Google Sheets with LiveFlow

Learn how to do this step-by-step in the video below 👇

Do you need personal help?

Our team of real people are here to help you any time between 9am and 10pm GMT.
Check Icon
Email us at:
Check Icon
Call us at +1 (415) 650-1711