Khyber Academy Khyber Academy is a free source of learning about Science, Technology, WordPress, SEO, and makes money online to prepare yourself for the future.
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
