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:
- Move your cursor to a tab of the sheet you want to copy.
- Right-click and choose “Duplicate”.
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/630950a09fb14fa20e16e779_S00S9sYgrDV7XRHDwcQJiXW8hyaLrxIcFt-9vdCRMUL6F21ZKBHVVJCd94If-hmVwNMbrIvpq9GtlTd76otDwaA98j3yskmpABUhZpfQNst-1vHX_xRnWgEUBP7HeE2Oi0ncfXfEvndw-qwtLqvP_74.png)
If you want to copy a worksheet to another file (new or existing one):
- Go to a tab of the sheet you want to duplicate.
- Right-click and choose “Copy to”.
- If you want to make a copy of the sheet in a new Google Sheet file, click “New spreadsheet”.
- 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.
![](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/630950a030a32558eff1fdf4_89jSYRbXdtIvxiPdwXHC9q-vKDDMV_Av84V_pwAQFHzUEk6ko1ZqjdfNb2wJTaduKW_xXqwS0mkyLXABjs4i85FlV1UDY8ea3BWx9WjyD0HI-LxP1DyW2f4nhdZAQDeRkdmXeqx5YMyXbNKvRxRcrPc.png)
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.