In Excel, you can copy or move a sheet to a new workbook or an already open workbook. And in this tutorial, we will learn this in detail.
- Copy – It creates a new copy and moves it to another workbook.
- Move – It moves the original sheet.
Let’s learn this.
Copy a Sheet to an Existing Sheet
- Right Click on the Sheet Tab and click “Copy or Move”.
- From the Dialog Box, use “To Book” drop down to select workbook. And from “Before Sheet” select the sheet before which you want to copy it.
- Next, tick marks the check box “Create a Copy”.
- In the end, click OK.
In this example, we have copied the sheet “Puneet” from Book2 to Book1.
Note: If you want to move the sheet instead of copying it, skip to tick-mark the “Create a Copy” check box.
Copy a Sheet to a New Sheet
In the same way, you can create a new workbook with the same option and copy or move a sheet to that workbook. When opening the “Move or Copy” dialog box, from the “To book;” drop-down, select (new book) and then click OK.
And when you click OK, Excel will instantly open a new workbook and copy the sheet into that new workbook.
Note: If you don’t want to create a copy of the sheet and want to move the sheet to a new workbook, skip to tick-mark “Create a Copy”.