EXCEL SHEETS

[Samantha]

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.

 

[Mike H]

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

 

[Harald Staff]

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

 

[Per Jessen]

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.