copy worksheet from one xls file to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bhavik.patel@gmail.com - 27 Sep 2006 13:38 GMT

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

Reply to this Message

Don Guillett - 27 Sep 2006 13:42 GMT

Have you tried right click sheet tab>move or copy

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hello,
>
[quoted text clipped - 8 lines]
>
> Regards

Reply to this Message

Paul - 27 Sep 2006 19:44 GMT

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

> Hello,
>
[quoted text clipped - 8 lines]
>
> Regards

Reply to this Message

Gord Dibben - 27 Sep 2006 20:20 GMT

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

>Hello,
>
[quoted text clipped - 8 lines]
>
>Regards

Reply to this Message