Microsoft Excel 2007 tutorial: copy worksheet


Copy worksheet

XI. Copy worksheet

In the previous section, you learned how to move worksheet(s) and now you learn how to copy worksheet(s). The ways to move and copy worksheet are very similar. After you learn this section, you can compare how similar for these two points are.

You can copy worksheet(s) from a workbook to another workbook. In copying worksheet, you have a couple of ways: copying a worksheet and more than one worksheets.

XI.1. Copy a worksheet

To copy a worksheet, follow the procedure below:

- Right-click any worksheet you want to copy.

- Click Move or Copy...

Excel 2007 copy sheet

or

- Click the sheet you want to copy.

- In the Home tab, in the Cells group, click drop-down arrow in front of Format, and then click Move or Copy Sheet..., under Organize Sheets.

Excel 2007 Move or Copy tool

Excel 2007 displays Move or Copy dialog box as the figure:

Excel 2007 Move or Copy dialog box

This dialog box allows you to select the workbook that you intend to copy the worksheet(s) to, and shows the sheets that the workbook contains, in the list under Before sheet. If you want to copy and move the sheet(s) to the end of other sheets, click (move to end) and check Create a copy check box.

- Click drop-down arrow of combo box to choose the workbook that you want to copy to.

- Check Create a copy check box, and then click Ok.

For example, you want to copy 302 sheet of Student List workbook to a new workbook. To this task, follow the procedure below:

- Right-click 302 sheet

- Click Move or Copy...

or

- Click 302 sheet

- In the Home tab, in the Cells group, click drop-down arrow in front of Format, and then click Move or Copy Sheet..., under Organize Sheets.

Excel 2007 displays Move or Copy dialog box.

- Click drop-down arrow of combo box, select (new book).

- Check Create a copy check box.

- Click Ok

Excel 2007 copy sheet to new workbook

After you clicked Ok, Excel 2007 creates a new workbook with a copied sheet. See the figure:

Excel 2007 new book with copied sheet

XI.2. Copy more than one worksheets

To copy more than one worksheets, you just select the worksheets that you want to copy and then follow the procedure of copying a worksheet.

For example, in the Student List workbook, there are four sheets (302, 401, 203, 404) as the figure:

Excel 2007 Student List workbook

You want to copy 302 and 404 sheets to Book2 workbook. To solve this task, follow the procedure below:

- Select 302 and 404 sheets by clicking 302 and holding down Ctrl key, and then clicking 404.

- Right-click 302 or 404 sheet

- Click Move or Copy...

or

- Select 302 and 404 sheets

- In the Home tab, in the Cells group, click drop-down arrow in front of Format, and then click Move or Copy Sheet..., under Organize Sheets.

Excel 2007 displays Move or Copy dialog box.

- Click drop-down arrow of combo box to select Book2.

-Check Create a copy, and then click Ok.

 


Comments





This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.