How to Duplicate a Sheet in Excel?

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.

How to Duplicate a Sheet in Excel

Step-3: Select (new book) from the list

Step-4: Check the Create a copy box.

Step-5: Ok

See in the below screenshot

Move or Copy to Create a Duplicate Sheet

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

Move or Copy Sheet in Excel

 

Back to Microsoft Excel Tutorial