Duplicate a sheet in Google Sheets
Duplicate the Practice sheet using its sheet-tab menu, then rename the duplicate Practice Copy. Keep the original Practice sheet.
Verified by JosephineAbout 60 secondsDuplicate the Practice sheet using its sheet-tab menu, then rename the duplicate Practice Copy. Keep the original Practice sheet.
Step-by-step
Select the targetDuplicate the Practice sheet.
Complete the next actionits sheet-tab menu.
Complete the next actionrename the duplicate Practice Copy.
Apply the changeKeep the original Practice sheet.
Shortcut or faster method
Use the menu path shown in the video and keep the target range selected until the change is applied.
Expected result
Both the original Practice sheet and a visible duplicate named Practice Copy exist.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Undo the last change, reselect the intended range, and try again. Both the original Practice sheet and a visible duplicate named Practice Copy exist.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Quarter | Revenue |
| Q1 | 120 |
| Q2 | 180 |
| Q3 | 240 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Duplicate the Practice sheet.
- Complete the next action. its sheet-tab menu.
- Complete the next action. rename the duplicate Practice Copy.
- Apply the change. Keep the original Practice sheet.
- Both the original Practice sheet and a visible duplicate named Practice Copy exist.