Moving and Copying Worksheets

When working with multiple worksheets in a workbook, you may find that you are not happy with the original order of the worksheets. You can move worksheets around, rearranging them into the most logical order. You can also copy worksheets within a workbook. But be careful—copying and moving worksheets can affect formulas and charts, and moving a worksheet may cause errors in your workbook.

To move a worksheet within a workbook:

1. Click the sheet tab of the worksheet you want to move.
2. When the cursor changes to a , drag the worksheet to the new position.

To copy a worksheet within a workbook:

1. Press on the keyboard and click the sheet tab of the worksheet you want to copy.
2. When the cursor changes to a , drag the worksheet to the new position.

To move more than one worksheet, press on the keyboard and click the worksheets you want to move. If the worksheets are not consecutive, then press on the keyboard instead.

1. Select the worksheet you want to move and select Move or Copy Sheet... from the Edit menu.
2. Right-click the sheet tab, and select Move or Copy... from the shortcut menu.
   1. Select the sheet you want to move the worksheet before.
   2. Check the Create a copy checkbox, if you want to make a copy of the worksheet.
   3. Click OK.