Skip to main content

Move or copy worksheets or worksheet data

You can move or copy a worksheet in the same workbook to organize your workbook exactly how you want.

You can use the Move or Copy Sheet command to move or copy entire sheets, to other locations in the same or a different workbook.

You can use the Cut and Copy commands to move or copy a portion of the data to other worksheets or workbooks.

Move a worksheet within a workbook

  • Select the worksheet tab, and drag it to where you want it.

Copy a worksheet in the same workbook

  • Press CTRL and drag the worksheet tab to the tab location you want.


  1. Right click on the worksheet tab and select Move or Copy.
  2. Select the Create a copy checkbox.
  3. Under Before sheet, select where you want to place the copy.
  4. Select OK.

Leave a comment

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

Format your code: <pre><code class="language-vba">place your code here</code></pre>