Copy or Move a Worksheet

To copy a worksheet within the current workbook or to copy and move a worksheet to another workbook.

• Hold the CONTROL key and click (or if you have a two-button mouse, simply right-click) on the worksheet that you want to edit.
  

• In the menu that appears, select Move or Copy…
  

• The Move or Copy Window appears.
  

In the To book list, do one of the following:

• Click the workbook to which you want to move or copy the selected sheets.
  

• Click new book to move or copy the selected sheets to a new workbook.
  

In the Before sheet list, do one of the following:

• Click the sheet before which you want to insert the moved or copied sheets.

• Click move to end to insert the moved or copied sheets after the last sheet in the workbook and before the Insert Worksheet tab.
  

To copy the sheets instead of moving them, select the Create a copy check box.

Tip:  To move sheets within the current workbook, you can drag the selected sheets along the row of sheet tabs. To copy the sheets, hold down CTRL, and then drag the sheets; release the mouse button before you release the CTRL key.

Note: When moving or copying a worksheet to another workbook, the workbook that you are moving the worksheet to must be open.