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

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

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

Dear Epinn,

thank you very much: it was just in front of my eyes!

But please try to explain me exactly what I should do in order to use
the Format Painter.
I made several tests, but haven't been able to copy the formats.
(e.g. select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)
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

I didn't paste the instructions from Help to the post because I tried to save storage.

But now I have found a link that can help you. If you click on the following link, you should be able to see the action. I like MS demos. Hope you like it too.

http://office.microsoft.com/en-us/as...176101033.aspx

If you have any more questions, feel free to post again.

Good luck!

Epinn

"horst" wrote in message ...
Dear Epinn,

thank you very much: it was just in front of my eyes!

But please try to explain me exactly what I should do in order to use
the Format Painter.
I made several tests, but haven't been able to copy the formats.
(e.g. select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)
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

select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)

Click on destination first cell and drag.

Epinn

"horst" wrote in message ...
Dear Epinn,

thank you very much: it was just in front of my eyes!

But please try to explain me exactly what I should do in order to use
the Format Painter.
I made several tests, but haven't been able to copy the formats.
(e.g. select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)
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

Thank you very much.
I have now been able to use Format Painter in Word, but not in Excel!
I drag on the destination cells, but nothing changes!
Any additional hints, please?
Horst

On 22.09.2006 22:33, Epinn wrote:
select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)

Click on destination first cell and drag.

Epinn

"horst" wrote in message ...
Dear Epinn,

thank you very much: it was just in front of my eyes!

But please try to explain me exactly what I should do in order to use
the Format Painter.
I made several tests, but haven't been able to copy the formats.
(e.g. select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)
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

Did you watch the demo (i.e. the link I included in the post)? Did it not help?

Actually, just clicking the first destination cell and without dragging works for me. I use V 2003.

Do you want to see if you can at least do the following?

Start a new sheet. Select A1:A10, click the fill color icon; any color is fine. So A1:A10 is filled with a color.

While A1:A10 is still *selected*, click on the format painter icon.

Then position the cursor (paint brush) in D1, click once. Did you get D1:D10 filled with the same color?

Epinn

"horst" wrote in message ...
Thank you very much.
I have now been able to use Format Painter in Word, but not in Excel!
I drag on the destination cells, but nothing changes!
Any additional hints, please?
Horst

On 22.09.2006 22:33, Epinn wrote:
select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)

Click on destination first cell and drag.

Epinn

"horst" wrote in message ...
Dear Epinn,

thank you very much: it was just in front of my eyes!

But please try to explain me exactly what I should do in order to use
the Format Painter.
I made several tests, but haven't been able to copy the formats.
(e.g. select source range, click Format Painter Icon, click on
destination first cell, click Ctrl-V ????)
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