Move and Copy worksheets quickly

Reading time: 2 minutes
Last Updated on 27/11/2019 by Frédéric LE GUEN

In Excel, there are a lot of tips and tricks to move or copy a worksheet. Here are some examples:

Move sheets in a workbook

To move a worksheet within a workbook, you just have to:

  • Click on the tab of the worksheet you want to move
  • Hold and drag your mouse
  • Release the mouse button (drop)
Move worksheet in a workbook

Duplicate a sheet in a workbook

The technique is similar to that for moving a sheet. You drag & drop the tab and, at the same time, press the Ctrl key on your keyboard.

Inside the icon you can see the symbol "+" (indicating you are copying the worksheet).

Copy a worksheet in a workbook with the Ctrl Key

Copy a worksheet to a new workbook

This technique works with any version of Excel. If you want to copy a worksheet to a new workbook, you can do it like this:

  1. Select the worksheet you want to export
  2. Right-Click
  3. Select Move or Copy
  4. In the upper dropdown list the option (New book)
  5. Check the option Create a copy

If you just want to move the original worksheet to a new workbook, don't check the option "Create a copy".

Move / Copy between workbooks

In Excel 2013 and later, it is possible to drag & drop a worksheet between 2 workbooks.

  1. Place your workbooks side by side
  2. Select the worksheet you want to transfer
  3. Drag & drop
  4. Your worksheet has been moved 😍😎
  5. If you want to copy (instead of move), press the Ctrl key in the same time. Otherwise the data will be moved by default.
Move or copy a workbook in a new workbook by drag&drop

If you have Excel 2010 and previous versions, this technique is not possible

Leave a Reply

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

Move and Copy worksheets quickly

Reading time: 2 minutes
Last Updated on 27/11/2019 by Frédéric LE GUEN

In Excel, there are a lot of tips and tricks to move or copy a worksheet. Here are some examples:

Move sheets in a workbook

To move a worksheet within a workbook, you just have to:

  • Click on the tab of the worksheet you want to move
  • Hold and drag your mouse
  • Release the mouse button (drop)
Move worksheet in a workbook

Duplicate a sheet in a workbook

The technique is similar to that for moving a sheet. You drag & drop the tab and, at the same time, press the Ctrl key on your keyboard.

Inside the icon you can see the symbol "+" (indicating you are copying the worksheet).

Copy a worksheet in a workbook with the Ctrl Key

Copy a worksheet to a new workbook

This technique works with any version of Excel. If you want to copy a worksheet to a new workbook, you can do it like this:

  1. Select the worksheet you want to export
  2. Right-Click
  3. Select Move or Copy
  4. In the upper dropdown list the option (New book)
  5. Check the option Create a copy

If you just want to move the original worksheet to a new workbook, don't check the option "Create a copy".

Move / Copy between workbooks

In Excel 2013 and later, it is possible to drag & drop a worksheet between 2 workbooks.

  1. Place your workbooks side by side
  2. Select the worksheet you want to transfer
  3. Drag & drop
  4. Your worksheet has been moved 😍😎
  5. If you want to copy (instead of move), press the Ctrl key in the same time. Otherwise the data will be moved by default.
Move or copy a workbook in a new workbook by drag&drop

If you have Excel 2010 and previous versions, this technique is not possible

Leave a Reply

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