Microsoft Office Tutorials and References
In Depth Information
Naming and renaming worksheets
Dragging worksheets between workbooks
You can move and copy worksheets between workbooks by dragging. You use the same
methods to move and copy that you use for worksheets in the same workbook. For
example, with two workbooks arranged horizontally in the workspace, you can move
a worksheet from one to the other by dragging it to the new location in the other
workbook:
This removes the sheet from the source workbook and relocates it in the destination
workbook; to copy it, press Ctrl while dragging. Note that you must arrange the two
workbooks together on your screen to allow this to work. To do so, click the View tab
on the ribbon, and then click the Arrange All button in the Window group and select
an arrangement option (Horizontal in the illustration just shown).
Search JabSto ::




Custom Search