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.

Get more Google Sheets stuff

Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.