position the cursor with the paint brush in D1,
click and... nothing happens

After you clicked the format painter, did you see the border of the selected range (A1:A10) "move/revolve?

Epinn

"horst" wrote in message ...
I followed your advices, position the cursor with the paint brush in D1,
click and... nothing happens (only the brush disappears)!
I have version 2002 SP2
???
Horst

On 24.09.2006 05:29, Epinn wrote:
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