In Excel, if you want to create a duplicate sheet which means creating a sheet’s copy within the same workbook, you can use two different methods.
- Drag and Drop with Mouse.
- Create a Duplicate Copy with Copy and Move
In this tutorial, we are going to look at both methods.
Drag and Drop to Create a Duplicate Sheet
- First, activate the sheet for which you want to create a copy.
- Now, press the Ctrl key.
- After that, by holding the Ctrl key, click on the sheet tab.
- In the end, drag and drop the sheet to a new place within the sheet tabs.
It creates a duplicate sheet of the sheet, which drags and drops.
You can see in the above example; you have a new duplicate sheet of “Sheet3” with (2) along with the original name.
Use Copy and Move to Create a Duplicate Copy of the Sheet
When right click on a sheet tab, you can see the options “Move or Copy” there. This option allows you to copy the sheet to a new workbook or an existing one that is open.
But with the same option, you can create a duplicate sheet copy within the same workbook. When you click on the option, it shows you a dialog box to select the destination to copy the sheet.
In the Move or Copy dialogue box, tick-mark the “Create a copy” checkbox, and make sure to have the same workbook name in the “To book:”. In the end, click OK to create a duplicate copy.
You can choose the position to add the duplicate sheet in this dialogue box.
Note: From both methods, the first method is quick and easy. But you can use any of these according to your preference.
Excel Basics / Excel Worksheet
More Tutorials
- Consolidate Data from Multiple Worksheets
- Rename Sheet in Excel
- Group Worksheets in the Excel
- View Two Sheets Side by Side in Excel
- Add a Worksheet in Excel
- Change Tab Color in Excel (Worksheet Tab)
- Add Title to a Worksheet in Excel
- Copy or Move a Sheet (Worksheet)
- Select All the Worksheets (Sheets)