moving a worksheet..?

R

Roy

Good evening,
how do I take a worksheet from one wookbook and insert it in a diffeent
workbook, thx in advance
 
D

Dave Peterson

Open both workbooks.
Select the workbook with the worksheet to move or copy.
select the worksheet in that workbook.
Edit|Move or copy sheet

Follow that dialog options.

Remember to check that box at the bottom if you want to copy the sheet.

======
You can also get that dialog by rightclicking on the worksheet tab.

======
And if you use Window|Arrange|horizontal (say), you can simply click on the
worksheet tab and drag from one workbook to the other. (Use click and ctrl-drag
to copy.)
 
G

Gord Dibben

With both workbooks open.

Right-click on the sheet tab and "Move or Copy"

You can move it or copy to the other book under the "to book" option.


Gord Dibben MS Excel MVP
 
Top