– How to Copy a Worksheet within the Workbook
Instead of copying contents, you can copy the whole worksheet and make it as a new worksheet. To copy a worksheet to another workbook, please follow the steps below for details:
Step 1: Click anywhere in the worksheet that you need to move;
Step 2: Click the "Home" tab from the ribbon;
Step 3: Click "Format" in the "Cells" section, and select "Move or Copy Sheet";
Step 4: In the new window, select "new book" in the first box, or an existing workbook name;
Step 5: Click "OK" at the bottom.
In an alternative way, right-click on the worksheet name and select "Move or Copy …" from the dialog box.