Microsoft Office Tutorials and References
In Depth Information
Shifting Sheets to Other Workbooks
Figure 7-9:
Use the
Move or
Copy dialog
box to move
or copy from
the current
into a
If you prefer a more direct approach, you can move or copy sheets between
open workbooks by dragging the sheet tabs from one workbook window to
another. This method works with several sheets or a single sheet; just be
sure that you select all the sheet tabs before you begin the drag-and-drop
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 or remove your finger or stylus from
the touchscreen.
Search JabSto ::

Custom Search