Excel - Format Painter shortcut?

Asked By LurfysMa on 14-Mar-07 01:12 AM
Is there a built-in keyboard shortcut for the Format Painter?

If not, is there a way to to assign to some key combination? I know I
can assign a key combination to a macro, but I would prefer not to
write a macro just to get a keyboard shortcut for a standard function.

Thanks

--
Running Excel 2000 SP-3 on Windows 2000


Michae replied on 15-Mar-07 09:57 AM
i do not know of any but you could copy the cell with the correct  paste
special>formats and then use F4 to repeat the action in each cell you want to
format
David McRitchie replied on 23-Mar-07 06:49 PM
Hi "LurfysMa",
You can use a macro and assign a shortcut key.
Pasting Formats, as in Format Painter     (#painter)
http://www.mvps.org/dmcritchie/excel/paste.htm#painter
should satisfy the requirement to not write a macro if it already
exists.

To install the macro you find there see
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro
To install the shortcut key  Ctrl+Shift+P or other shortcut of your choice see
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#shortcut
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
Nathan Larson replied on 24-Aug-07 09:19 AM
I wish there were a built-in keyboard shortcut for the format painter in Excel. There is one in Word - just highlight some text, use Ctrl-Shift-C to copy the format, highlight the text whose format you want to change, and then use Ctrl-Shift-V to paste it. I tried it in Excel but it didn't work.