How to Move a Worksheet to a New Workbook

– How to Move a Worksheet Within the Workbook

Instead of copying contents from one worksheet to another, you can move the worksheet to a new one and save as a new workbook, please follow the steps below for details:

Step 1: Right-click on the worksheet name;

Step 2: In the dialog box, select "Move or Copy Sheet";

Step 3: In the new window, select "new book" in the first box;

Step 4: Click "OK" at the bottom.

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 "Format" in the Cells section, and select the "Move or Copy Sheet";

Step 3: In the new window, select "new book" in the first box;

Step 4: Click "OK" at the bottom.