Move or Copy Sheet in Excel
When you need to create a new spreadsheet based on an existing one or move a sheet from one excel file to another, you can move or copy a worksheet in the same workbook or another workbook.
1. Move or Copy a worksheet in the same workbook
Open the worksheet you want to move or copy.Home > format > move or copy sheet… (you can also open this option using right click on sheet Tab)
The Move or Copy dialog box will then open.Choose where you want to place the copy.Click on Create a copy box. (If you don't Click the create a copy box, Excel will only move the sheet.)Click OK.
2. Move or Copy a worksheet to another workbook
Open the worksheet you want to move or copy.Home > format > move or copy sheet… (you can also open this opt...