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???