Move and copy of Excel2010 worksheets

You can move or copy a worksheet in Excel 2010 to another location within the workbook or to another workbook. However, you need to be very cautious when you move or copy a worksheet. If you move a worksheet, calculations or charts based on worksheet data may become inaccurate. Similarly, if you insert a moved or copied worksheet by a three-dimensional formula reference (three-dimensional reference: a reference to a range that spans two or more worksheets in a workbook.) ), the data on that worksheet may be included in the calculation.

1. To move or copy the worksheet to another workbook, make sure that the workbook is open in Microsoft Office Excel.

2. In the workbook that contains the worksheet that you want to move or copy, select the worksheet that you want.

How to select a worksheet

Tip When you select more than one worksheet, the word [workgroup] appears in the title bar at the top of the worksheet. To deselect more than one worksheet in a workbook, click any unselected worksheet. If you don't see a worksheet that is not selected, right-click the tab for the selected worksheet, and then click Ungroup Sheet on the shortcut menu.

3, on the Start tab, in the Cells group, click Format, and then under organization sheet, click Move or Copy Sheet.

Tip You can also right-click the selected sheet tab, and then click Move or Copy Sheet on the shortcut menu.

4, in the workbook list, do one of the following:

• Click the workbook that you want to move or copy the selected worksheet to.

Click New workbook to move or copy the selected worksheet to the new workbook.

5. In the list before the selected worksheets below, do one of the following:

Click the worksheet before which you want to insert the moved or copied worksheet.

Click Move to last to insert the moved or copied worksheet after the last worksheet in the workbook and before the Insert Sheet tab.

6. To copy the worksheets without moving them, select the Make copies check box.

Tip To move a worksheet in the current workbook, you can drag the selected sheet along the tab row of the worksheet. To copy a worksheet, hold down CTRL, and then drag the worksheet you want, release the mouse button, and then release the CTRL key.