Format Painter in Microsoft Office

I know I can google it quite easily but hey, I have never asked any question @ SU, so here is one.

What is the shortcut key for Format Painter in Microsoft Office things e.g., Microsoft Word?

4 Answers

The answer is to use Ctrl+Shift+C to Copy Format and Ctrl+Shift+V to Paste Format.

The official Office-wide Format Painter key combination is

Alt+h+f+p

This is awkward to press, though, especially when standing up.

So I automated this with an Autohotkey script:

^Numpad0::
Send, {ALTDOWN}hfp{ALTUP}
return

There is no paste required - if Alt+h+f+p is done correctly, you should get the paintbrush appear, and you can then apply it, but only to one location.

HOWEVER: In the mouse-click version, double clicking on the Format Painter icon gives you the opportunity to apply the format multiple times, to numerous separate locations.

How does one do that with the keyboard, for Excel?

The answer from:

Click in the text with the formatting you want to apply.
Press Ctrl+Shift+C to copy the formatting (make sure you include the Shift as Ctrl+C only copies the text).
Click in the text to which you want to apply the formatting.
Press Crtl+Shift+V. You can press this key combination as many times as you like while the document is open — it retains the copied formatting until you do step 2 again.

...doesn't work for Excel.

Ctrl+Shift+C to copy the formatting (make sure you include the Shift as Ctrl+C only copies the text). Click in the text to which you want to apply the formatting. Press Crtl+Shift+V.

Its works perfectly fine in MS Outlook as well.