– How to Copy a Worksheet to another Workbook
Instead of copying contents, you can copy the whole worksheet and make it as a new worksheet. To copy a worksheet within the workbook, please follow the steps below for details:
Step 1: Right-click on the worksheet name and select "Move or Copy…" from the dialog box;
Step 2: Select the location where you want to copy to, and check the "Create a copy" box at the bottom;
Step 3: You will see a new worksheet now is available, double click and change the sheet name.
Alternatively, please use the commands from the ribbon.
Step 1: Click anywhere in the worksheet that you need to move;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click the "Format" in the Cells section, and click "Move or Copy Sheet" from the drop-down list;
Step 4: Select the location where you want to copy to, and check the "Create a copy" box at the bottom;
Step 5: Click "OK" at the bottom.
