EXCEL SHEETS
 

I have two Excel files containing several sheets each. How do I move a sheet
from one file / workbook to the other, but the column widths are differeant
and row heights for the sheets i need to add to the other sheets, i need to
retain the formatting on the sheets that i will be adding to the other
sheets. Thanks.

EXCEL SHEETS
 

Samantha,

Select all the cells in the source sheet and copy then select A1 in the
recieving sheet and

Edit|Paste Special - select ALL
OK

Mike

"Samantha" wrote:

I have two Excel files containing several sheets each. How do I move a sheet
from one file / workbook to the other, but the column widths are differeant
and row heights for the sheets i need to add to the other sheets, i need to
retain the formatting on the sheets that i will be adding to the other
sheets. Thanks.

EXCEL SHEETS
 

Hi

Rightclick the sheet tab(s), select "Move or copy" and follow the wizard.
(You lost me on the formatting problem, sorry :-)

HTH. Best wishes Harald


"Samantha" wrote in message
...
I have two Excel files containing several sheets each. How do I move a
sheet
from one file / workbook to the other, but the column widths are
differeant
and row heights for the sheets i need to add to the other sheets, i need
to
retain the formatting on the sheets that i will be adding to the other
sheets. Thanks.

EXCEL SHEETS
 

Hi

Right click on the sheet tab you want to copy, select "Move or Copy"
Select the book to move to. Check "Create a copy" if you want to copy the
sheet.

Hopes this helps.

---
Per

"Samantha" skrev i meddelelsen
...
I have two Excel files containing several sheets each. How do I move a
sheet
from one file / workbook to the other, but the column widths are
differeant
and row heights for the sheets i need to add to the other sheets, i need
to
retain the formatting on the sheets that i will be adding to the other
sheets. Thanks.