Is ther a keyboard shortcut to the format painter and if not what is the code
line i should use to create my own shortcut plaese

Judith :

A few links on keyboard shortcuts, et al.

Chip Pearson
http://www.cpearson.com/excel/ShortCuts.htm

David McRitchie
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

I've never seen a shortcut for the Format Painter. David McRitchie's
site has a link to a macro that provides some functionality. Search
the page for 'Painter'.

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

Is ther a keyboard shortcut to the format painter and if not what is the code
line i should use to create my own shortcut plaese

If you copy the cell (CTRL-C), then select your target and type

ALT-E, S, T, ENTER

you'll accomplish the same thing.

In article ,
judith wrote:

Is ther a keyboard shortcut to the format painter and if not what is the code
line i should use to create my own shortcut plaese