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 option using right click on sheet Tab)
- The Move or Copy dialog box will get open.
- Under To shown workbook dropdown, choose the target workbook. (Make sure the targeted workbook is open in the background or you choose a new book)
- Under Before sheet list, specify where to put the copy.
- Click on Create a copy box. (If you don’t Click the create a copy box, Excel will remove the sheet from existing workbook to a new targeted book ( In otherwords cut & paste ).
- Once all selection is done Click OK.
