Move and copy of Excel2010 worksheets

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.