copying worksheets to mane one document.
 

Hi,

I am trying to organize a manual for the company I work for. I have tried
copying one worksheet into another but it doesnt copy it in the format that
it was, the cells size changes and is a mess to try to fix them. Let me
explain better... the manual has several chapters and each chapter has
several pages.... these pages were saved one by one, so what i want to do is
create an excel document where a tab is a chapter. so in each tab/chapter
will be several pages but I want to copy these pages with the same appearance
and I cant!! Can someone help me???

copying worksheets to mane one document.
 

Hi

Look at "Past special", it gives you the option to paste formats, column
widths and more.

Regards,

Per

"Charimilly" skrev i en meddelelse
...
Hi,

I am trying to organize a manual for the company I work for. I have tried
copying one worksheet into another but it doesnt copy it in the format
that
it was, the cells size changes and is a mess to try to fix them. Let me
explain better... the manual has several chapters and each chapter has
several pages.... these pages were saved one by one, so what i want to do
is
create an excel document where a tab is a chapter. so in each tab/chapter
will be several pages but I want to copy these pages with the same
appearance
and I cant!! Can someone help me???