Of course there is already a Ctrl+Shift+C and Ctrl+Shift+V
so you'd want to make sure you don't mind losing them
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
In other words all the good shortcuts are taken.

You might take a look at
http://www.mvps.org/dmcritchie/excel/paste.htm#painter

Which uses your normal Ctrl+C and you add a Ctrl+Shift+P
as in (Format) Painter.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Ron de Bruin" wrote in message
...
Hi Nathan

You can create your own macro with this code line

Application.CommandBars("Standard").FindControl(ID :=108).Execute

Assign the shortcut you want to it


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Nathan Larson" wrote in message
...
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.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com