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
Click on the small down arrow beside the name of the sheet you want to duplicate to open the sheet menu
Click on the Duplicate option near the top
An exact copy of your sheet will be created with the phrase “Copy of “ prepended on the name of the sheet
To rename the duplicate sheet, click on the down arrow beside the sheet name, and choose the Rename option
Type in the new name for the sheet, then hit enter on the keyboard to update the name
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.