Excel+move+a+worksheet+to+another+workbook

Excel move a worksheet to another workbook

You are probably familiar with the fact that you can move worksheets around in an Excel file This you do by clicking and dragging.

However, do you know that you can move a worksheet to another workbook?

Well you can and here is how:-

First you must open both workbooks. That is the one with the worksheet completed, and the one to which the worksheet needs to be relocated.

Arrange your workbooks side by side using the Window menu, Arrange choice and then making a choice from the Arrange window. Click OK.

Now Click and hold the sheet tab to be moved. Whilst holding down the left-button drag the sheet tab into the other file

A small triangle will appear when a sheet as been moved, this assists you as to where the sheet is located.

That’s it Oh do not forget to release the mouse button  