Copy or Move Worksheets...
... from one Workbook to Another
"I use Microsoft Excel, as a learning provider administrator, I often run into the situation where the information in a worksheet is needed in another workbook. I currently go through and copy and paste the cells from one worksheet to another, but when I'm working with a large spreadsheet, I feel "There must be an easier way!"."
"Is there an easier way?"
There is indeed! Excel makes it easy to copy (and even easier to move) worksheets from one workbook to another...
1: Copying a worksheet to another workbook:
- Open the workbook that has the worksheet you wish to move;
- Open the workbook that you want the worksheet copied to; (in my example, we will use Book1 and Book2).
- Go to the workbook with the desired worksheet.
- Right-click on the tab of the target worksheet (in this case, Staff sheet).
- Select Move or Copy from the menu that appears;
- When the Move or Copy dialog box appears...
....use the To book dropdown to select the workbook that you want to copy the worksheet to. Then...
...Select the existing sheet that you want the copy to be placed in front of;
...Finally, check the Create a copy checkbox;- Click OK.
You will now have the same worksheet in both workbooks.
Copying a worksheet to another workbook:
This Captivate Flash Object shows how to "Copy a worksheet from one workbook to another workbook". Click the window to activate it.
Use the rewind, play, pause etc. buttons at the bottom of the playback window.
You can use the above steps and simply exclude checking the Create a copy checkbox, but there is a simpler and quicker way to do this:
- Have both workbooks open. Do not maximize either one, you want to be able to see both of them.
- Left click and drag the tab of the target worksheet to the desired workbook.
- When you release the mouse button, the worksheet will be in the targeted workbook and no longer in the original spreadsheet.
Moving whorksheets from one to another workbook.
This Captivate Flash Object shows how to "Move a worksheet from one workbook to another workbook". Click the window to activate it.
Use the rewind, play, pause etc. buttons at the bottom of the playback window.
PS If you hold down the Control Key,
...as you drag the worksheet from one book to another, you will get the same result as for Number 1 above!
Licensed under the GNU Free Documentation License
Produced and edited by John Dalziel (eLearning Adviser) JISC RSC-Northwest