copy with format
Dear Epinn,
thank you very much: it was just in front of my eyes!
But if I copy and paste to an existing sheet I loose all formattings
(sizes, borders etc.)
The small image "Paste options" gives me only the choices of using
destination formats or Text Import Wizard.
What I miss is the use of source formats.
I have v2002.
Horst
On 22.09.2006 02:40, Epinn wrote:
Do you want to copy to a brand new sheet or an existing sheet?
To a brand new sheet, I use edit move or copy sheet and then tick create a copy. This way I get all the formatting.
To an existing sheet, I do copy and paste and I get the formatting as well. If I do paste special, then I don't get the formatting. But I can use the format painter to finish the job. In case you need more info on format painter, Help has the details.
I use V 2003.
Hope this helps.
Epinn
"horst" wrote in message ...
I have a sheet with various formattings (background and text colored,
large and small texts, borders etc.).
When I copy and paste it into another sheet I get the text only and all
formattings are lost.
Paste special has only text and unicode.
Is there any way to copy everything?
Thanks
Horst
|