Shortcut to format painter

judith · Jan 17, 2005

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

pfsardella · Jan 17, 2005

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

JE McGimpsey · Jan 17, 2005

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

ALT-E, S, T, ENTER

you'll accomplish the same thing.