How to Copy a Worksheet to another Workbook

- 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.

Leave a Reply