Sometimes we need the same information or format of the existing excel sheet. Therefore, we may create a copy of the sheet (duplicate sheet) which can edit/modify. You can use the Move or Copy Sheet command to move or copy the entire sheet to other locations in the same book or to a different book.
For example, we need to create a duplicate sheet in excel or copy a sheet into the same or another workbook. The following easy steps could be followed.
How to Duplicate a Sheet in Excel?
Step-1: Right-click on the sheet tab you want to make a duplicate.
Step-2: Select Move or copy.
Step-3: Select (new book) from the list
Step-4: Check the Create a copy box.
Step-5: Ok
See in the below screenshot
Copy a Spreadsheet into the Same Workbook:
Two easy methods are used to copy a sheet into the same workbook.
Step-1: Press CTRL, hold and drag the spreadsheet tab to the tab location you want.
Or
Step-1: Right-click on the sheet tab.
Step-2: Select Move or copy.
Step-3: Check the Create a copy box.
Step-4: Ok
See in the below screenshot
Copy a Spreadsheet into the Same Other Workbook:
Step-1: Right-click on the sheet tab you want to make a duplicate.
Step-2: Select Move or copy.
Step-3: Choose the workbook name from the list where you want to move or copy the sheet.
Step-4: Check the Create a copy box.
Step-5: Ok
See in the below screenshot
Back to Microsoft Excel Tutorial
