Microsoft Excel 2007 tutorial: move worksheet


Move worksheet

X. Move worksheet

You can move worksheet(s) from a workbook to another workbook. In moving worksheet, you have two ways: moving a worksheet and more than one worksheets.

X.1. Move a worksheet

To move a worksheet, follow the procedure below:

- Right-click any worksheet you want to move.

- Click Move or Copy...

Excel 2007 move sheet

or

- Click the sheet you want to move.

- 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 move the worksheet(s) to, and shows the sheets that the workbook contains, in the list under Before sheet. If you want to move the sheet(s) to the end of other sheets, click (move to end). In addition, you can create a copy of the sheet that you had moved if you check Create a copy check box.

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

- Click Ok

For example, you want to move 302 sheet of Student List workbook to Book2 workbook. You also want the moved sheet locates at the end of other sheets of Book2 workbook and creates a copy when the sheet moves. To this task, follow the procedure below:

- Right-click 302 sheet

- Click Move or Copy...

Excel 2007 displays Move or Copy dialog box.

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

- Click (move to end), and then check Create a copy check box.

- Click Ok

Excel 2007 move sheet example

The figure below shows 302 sheet of Student List workbook before and after moves to Book2 workbook.

Excel 2007 before and after move sheet

X.2. Move more than one worksheets

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

For example, you have Student List workbook that contains four sheets (302, 401, 203, 404) as the figure:

Excel 2007 Student List workbook

You want to move 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, 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.