If you ever need to move or copy or move permantly a worksheet form one workbook to another then here is the best way to do it in Excel – using the Move or Copy Dialog Box.
- Firstly open the workbook that you want to move the worksheet to.
- Display the workbook that contains the worksheet you want to move or copy.
- Select the worksheet or sheets that you want to move or copy.
- Right click the sheet tab and select Move or Copy form the short cut menu.
- The Move or Copy Dialog Box opens.
If you want to copy the worksheet then just right ahead and tick the Copy option, leave blank to move the sheet entirely.
- In the To box select the workbook you want to move or copy your sheet to
- If you want to move to a new workbook rather than an existing one then select the (New Book) option in the To Book drop down list.
- All you need to do now is specify where in the destination workbook you want to move or copy the worksheet to.
- In the Before Sheet list box, select the name of the sheet that the worksheet you are about to move or copy should precede.
- If you want the moved or copied worksheet to appear at the end of the workbook then select the (move to end) option.
- You copied or moved worksheet should now be positioned exactly where you want it to be.
In my example here I am moving my worksheet from from my current workbook Widget Sales Summary.xlsx. I have ticked I want to just create a copy of the worksheet and insert it before the Summary worksheet in the Widget Sales Summary workbook.
How do you find this method of copying or moving Excel worksheets?.
Rick says
I am trying to copy a Worksheet from one Workbook over to a second existing Workbook. I have repeatedly followed the directions for using the “Move or Copy Dialog Box", but I get only as far as the “To book: “ on the dialog box. There I am presented with just two choices: 1) the source Workbook, or 2) “new book". I’m unable to type or browse to identify the target Workbook.
I’m running Office 2010 on a Windows 7 pro machine. Any suggestions?
Barbara says
Rick
Good question- have you got your destination workbook open that you want to copy to?. That is the only reason I have found that I get just source workbook and new book.
Let me know how you get on with that
Regards
Barbara