Breaking News

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

About Hikmat Ullah

Check Also

How to Change Font in PowerPoint

How to Change Font in PowerPoint?

In this lesson, we will learn how to change Font in PowerPoint? PowerPoint Font options …