Move or Copy Excel Sheets to other Workbooks in Excel 2007
In some situations, you need to move a particular worksheet or copy it from one workbook to another. To move or copy worksheets between workbooks, follow these steps:
1) Open both 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).
Click Office Button → Open or press Ctrl+O to open both the workbooks.
2) Select the workbook that contains the worksheet(s) that you want to move or copy.
To select the workbook with the sheet(s) to be moved or copied, click its button on the Windows Vista or XP taskbar.
3) Select the worksheet(s) that you want to move or copy.
To select a single worksheet, click its sheet tab. To select a group of neighboring sheets, click the first tab and then hold down Shift while you click the last tab. To select various nonadjacent sheets, click the first tab and then hold down Ctrl while you click each of the other sheet tabs.
4) Right-click its sheet tab and then click Move or Copy on its shortcut menu.
Excel opens up the Move or Copy dialog box in which you indicate whether you want to move or copy the selected sheet(s) and where to move or copy them.
5) In the To Book drop-down list box, select the name of 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 that appears at the very top of the To Book pop-up list
6) 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.
7) Select the Create a Copy check box to copy the selected worksheet(s) to the designated workbook (rather than move them)
8) Click OK or press Enter to complete the move or copy operation.
Drag and Drop method
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. 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.
To drag a worksheet from one workbook to another, you must open both workbooks. Click the Arrange All command button on the View tab or press Alt+WA and then select an arrangement (such as Horizontal or Vertical to put the workbook windows either on top of each other or side by side). Before you close the Arrange Windows dialog box, be sure that the Windows of Active Workbook check box is not selected, that is, does not contain a check mark.
After arranging the workbook windows, drag the worksheet tab from one workbook to another. If you want to copy rather than move the worksheet, hold down the Ctrl key while you drag the sheet icon(s).
To locate the worksheet in the new workbook, position the downward-pointing triangle that moves with the sheet icon in front of the worksheet tab where you want to insert it; then release the mouse button.
This drag-and-drop operation is one of those that you can't reverse by using Excel's Undo feature. This means that if you drop the sheet in the wrong workbook, you'll have to go get the wayward sheet yourself and drag it back and drop it into the place where it once belonged!
Tags: sheets,workbook,worksheet,cell
Related Articles