Wednesday, October 30, 2013

Move Or Copy Worksheets Between Excel Workbooks

Moving or copying worksheets from one workbook to another may sound like a complicated process but as with a lot of features in Excel it really is quite straightforward. I will describe in detail the two different methods. First I will cover Excel's built in method for completing this task, and as usual in Excel there is also an alternative way to carry out the task as well, which we will cover also.

To move or copy a worksheet from one workbook to another using Excel's in- built task.

Open the source and target workbook together. The source workbook contains the workbook you want to move or copy to your target. In the source workbook select the worksheet that you want to copy or move. Then go to your target workbook

Click the Home Tab, click Format drop down in the Cells Group and then select Move Or Copy Sheets in the Organize Sheets section. If you would prefer to by pass using the Excel Riboon then right click on the sheet tab you want to copy or move in the source workbook and choose Move Or Copy from the shortcut menu that appears.

In the Move Or Copy Dialog Box, just choose the target worksheet from the To Book drop down box. Excel will display only the workbooks you already have open. You should have already opened the target workbook at the very start of this task.

You now have even more choices to make once you have selected the target workbook. You can either put worksheet and the end of the workbook or select Before Sheet List Box that will allow you to select the name of the worksheet you want yours to precede.

If you want the moved or copied worksheet to appear at the end of the new workbook then select the option Move To End. Your moved or copied worksheet should now be positioned exactly where you want it. If you want to move rather than copy, just click Create A Copy option at the bottom of the dialog box. Just hit OK and your task is completed.

As I said earlier, there are usually a few ways to accomplish the same task with Excel. Here is another way, not exactly a shortcut but just an alternative process.

First you need to again open both the source and target workbooks. With them both open select the View Tab and select the Side By Side Option in the Window Group.

Click the sheet tab in the source workbook and drag it to the target workbook - this moves the worksheet. Alternatively if you want to copy worksheets then hold down the CTRL key while you drag the worksheet to the target workbook.

There you go, two ways to perform the same move or copy worksheets between workbooks in Excel.
BJ Johnston 50 Top Tips and Tricks. http://www.howtoexcelatexcel.com/

Labels: