copy worksheet from one xls file to another

[bhavik.patel]

Hello,

How can I copy an entire sheet from one XLS file to another?
I have tried Select All>Copy>Paste operation, but it does not resize
cells in the destination file.

The sheet I am copying is very big, so it's difficult to format all
cells againg in the destination file.

Please provide me solution.

Regards

 

[Don Guillett]

Have you tried right click sheet tab>move or copy

 

[Paul]

Try right click and pase special, you can paste the formats and either
numbers or formulae. 2003 combines these but if a previous version just pste
the number/formula then repaste the format.
Usually works for me.
good luck

 

[Gord Dibben]

Right-click on the sheet tab and "move or copy"

Checkmark in "create a copy"

In the "to book" select the target workbook and OK.


Gord Dibben MS Excel MVP