what is the keyboard combination for format painter?

[Guest]

Could someone help please?
I cant find keyboard shortcut combination for format painter.

 

[Peo Sjoblom]

Rhere is no shortcut for the format painter, of course one could use several
keypresses through alt + e + s + t + enter
but I suspect that is not what you want. You can create a macro with a
shortcut that will do it

 

[glnz]

Mr. Sjoblom: Thanks for info. What would that macro be in Excel 2003?

In my mind, I would create a macro that is the equivalent of pushing the
paintbrush icon. I would make it a keyboard macro, probably CTRL + SHIFT + C.

I don't think we need a macro to "paste" the formatting since the "pasting"
is done as soon as you touch a cell or sweep a range of cells. Am I correct?

Thanks.

 

[glnz]

Mr. Sjoblom - More info and question to you:

I tried to create my own macro for this, but (a) it doesn't "paste", and
when I try to get it to paste, I find the macro has copied cell contents, not
cell formatting. Inside the macro, the operative command appears as
"Select.Copy", which is obviously not what we'd want.

How do I get the macro to record the equivalent of "Copy Formatting"?

And then will it paste in the usual way, by my touching or sweeping the
target cells?