How to Move or Copy Excel 2010 Worksheets to Other Workbooks

By Greg Harvey from Excel 2010 For Dummies

In Excel 2010, 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).
Display the workbook that contains the worksheet(s) that you want to move or copy.
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 choose 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 box, select the workbook that you want to copy or move the worksheets to.

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.

Use the Move or Copy dialog box to move or copy worksheet(s) from the current workbook to another workbook.
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.
Click OK to complete the move or copy operation.

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.