Skip to Content

How to Duplicate a Sheet in Google Sheets

Sometimes when working in spreadsheet programs like Google Sheets, you may want to make a copy of your sheet.

There are a few different ways of doing this.

In this tutorial, I will show you how to duplicate a sheet and how to copy a sheet in Google Sheets

Table of Contents

How to Duplicate a Sheet

To quickly duplicate a sheet:

  1. Right-click on the tab in your workbook for the sheet that you want to duplicate
  2. Select Duplicate
  3. This will duplicate your sheet into the same workbook

Duplicate Sheet

How to Copy a Sheet

  1. In the top menu select File
  2. In the drop-down menu select Make a copy
  3. Name your copy and select Ok

Make a Copy

If you just want to copy one tab in your workbook you can right click on the tab and you will have options to copy to a new spreadsheet or an existing spreadsheet

Copy To

Closing Thoughts

Being able to copy your entire spreadsheet is something every Google Sheet user should know how to do. There will be many times where you need to duplicate your data and keep your original.

We hope you found this tutorial helpful!

More Google Sheets Tutorials:
How to Convert Excel to Google Sheets
How to Merge and Unmerge Cells
Convert Google Doc to Google Sheets