Microsoft Office Tutorials and References
In Depth Information
Shifting Sheets to Other Workbooks
Shifting Sheets to Other Workbooks
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).
Choose File 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 move or copy, click its
pop-up thumbnail on the Windows 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 (similar to the one shown
in Figure 7-9) 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 drop-down 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.
Search JabSto ::




Custom Search