Copy or Move a Sheet (Worksheet)

puneet-gogia-excel-champs

- Written by Puneet

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

  1. Right Click on the Sheet Tab and click “Copy or Move”.
    1-copy-a-sheet
  2. 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.
  3. Next, tick marks the check box “Create a Copy”.
    2-tickmark-create-a-copy
  4. In the end, click OK.

In this example, we have copied the sheet “Puneet” from Book2 to Book1.

sheet-copied-into-other-workbook

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.

copy-a-sheet-to-new-sheet

And when you click OK, Excel will instantly open a new workbook and copy the sheet into that new workbook.

sheet-copied-into-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”.

Last Updated: August 10, 2023