How to copy a Worksheet to Another Workbook?

How to copy a Worksheet to Another Workbook?
Last Updated on 25/07/2023
Reading time: < 1 minute

Do you know you can copy a worksheet from one workbook to another with a simple Drag & Drop? Here is the technique.

Steps to copy a worksheet to another workbook

  1. Open 2 workbooks, the one containing the sheet to copy and the one that will receive it
  2. Change the layout of workbooks so that both are visible on the screen
  3. Select the sheet to copy
  4. Press and hold the Control key until the end of the operation (a + icon appears)
  5. Click to move the sheet to the second workbook
  6. Release the mouse button, then the Control key
  7. The sheet was copied to the second workbook

The steps in Video

Copy a worksheet to another workbook

Move a worksheet to another Workbook

The technique to move a worksheet to another workbook is similar to the previous one, except you don't press the Ctrl Key.

  1. Open 2 workbooks, the one containing the sheet to copy and the one that will receive it
  2. Change the layout of workbooks so that both are visible on the screen
  3. Select the sheet to copy
  4. Click to move the sheet to the second workbook
  5. Release the mouse button, then the Control key
  6. The sheet was copied to the second workbook
Move or copy a workbook in a new workbook by drag&drop

Related articles

Leave a Reply

Your email address will not be published. Required fields are marked *

How to copy a Worksheet to Another Workbook?

Reading time: < 1 minute
Last Updated on 25/07/2023

Do you know you can copy a worksheet from one workbook to another with a simple Drag & Drop? Here is the technique.

Steps to copy a worksheet to another workbook

  1. Open 2 workbooks, the one containing the sheet to copy and the one that will receive it
  2. Change the layout of workbooks so that both are visible on the screen
  3. Select the sheet to copy
  4. Press and hold the Control key until the end of the operation (a + icon appears)
  5. Click to move the sheet to the second workbook
  6. Release the mouse button, then the Control key
  7. The sheet was copied to the second workbook

The steps in Video

Copy a worksheet to another workbook

Move a worksheet to another Workbook

The technique to move a worksheet to another workbook is similar to the previous one, except you don't press the Ctrl Key.

  1. Open 2 workbooks, the one containing the sheet to copy and the one that will receive it
  2. Change the layout of workbooks so that both are visible on the screen
  3. Select the sheet to copy
  4. Click to move the sheet to the second workbook
  5. Release the mouse button, then the Control key
  6. The sheet was copied to the second workbook
Move or copy a workbook in a new workbook by drag&drop

Related articles

Leave a Reply

Your email address will not be published. Required fields are marked *