How to Move or Copy Excel 2007 Worksheets to Other Workbooks
In Excel 2007, you may need to move or copy a particular worksheet from one workbook to another. You can use the Move or Copy dialog box to simplify the process. To move or copy worksheets between workbooks, follow these steps:
Open the workbook with the worksheet(s) that you want to move or copy and the workbook that is to contain the moved or copied worksheet(s).
Both the source and destination workbooks ned to be open, though you don't need to see both of them.
Display the workbook that contains the worksheet(s) that you want to move or copy.
This is your source workbook.
Select the worksheet(s) that you want to move or copy.
If you want to select a group of neighboring sheets, click the first tab and then hold down Shift while you click the last tab. To select nonadjacent sheets, click the first tab and then hold down Ctrl while you click each of the other sheet tabs.
Right-click one of the selected sheet tabs and then click Move or Copy on the shortcut menu.
Excel opens the Move or Copy dialog box, where you indicate whether you want to move or copy the selected sheet(s) and where to move or copy them.
In the To Book drop-down list, select the workbook to which you want to copy or move the worksheets.
If you want to move or copy the selected worksheet(s) to a new workbook rather than to an existing one that you have open, select the (New Book) option at the top of the To Book drop-down list.
Select where in the new workbook you want to drop the worksheets.
In the Before Sheet list box, select the name of the sheet that the worksheet(s) you’re about to move or copy should precede. If you want the sheet(s) that you’re moving or copying to appear at the end of the workbook, choose the (Move to End) option.
If you want to copy the sheets rather than move them, select the Create a Copy check box.
By default, this option is deselected.
Click OK to complete the move or copy operation.
A worksheet has found a new home!
If you prefer a more direct approach, you can move or copy sheets between open workbooks by dragging their sheet tabs from one workbook window to another (hold down the Ctrl key as you drag a sheet tab to create a copy). Use the Arrange All command on the View tab to display all workbooks onscreen. Note that this method works with a bunch of sheets as well as with a single sheet; just be sure that you select all their sheet tabs before you begin the drag-and-drop procedure.