Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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:

https://cybertext.wordpress.com/2009/01/21/word-run-format-painter-with-the-keyboard/

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.

share|improve this answer

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
share|improve this answer
1  
This is for copying the format. What is key combination for pasting it ? – mtk Aug 24 '12 at 7:10
up vote 8 down vote accepted

OK Since nobody is in answering mood, I googled this myself. And the answer is to use Ctrl+Shift+C to Copy Format and Ctrl+Shift+V to Paste Format.

share|improve this answer
1  
This only works in MS Word. – J. Polfer Jul 21 '10 at 14:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.