How To Duplicate A Sheet In Google Sheets

In this tutorial, you will learn how to duplicate a sheet in Google Sheets.

How To Duplicate A Sheet In Google Sheets

When working in Google Sheets, you’ll often find you need to make a copy of a sheet.

Instead of copying all the data and formulas manually, you can quickly make an exact copy of the sheet by following the steps below

Step 1

Click on the small down arrow beside the name of the sheet you want to duplicate to open the sheet menu

Step 2

Click on the Duplicate option near the top

Step 3

An exact copy of your sheet will be created with the phrase “Copy of “ prepended on the name of the sheet

Step 4

To rename the duplicate sheet, click on the down arrow beside the sheet name, and choose the Rename option

Step 5

Type in the new name for the sheet, then hit enter on the keyboard to update the name

Summary

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to duplicate a sheet in Google Sheets. Want more? Check out all the Google Sheets Tutorials.