Ask Different is a question and answer site for power users of Apple hardware and software. Join them; it only takes a minute:

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've been looking on the Internet for the shortcut to the Format Painter tool. No luck so far, it seems there's no shortcut for this tool. Maybe someone here knows better.

Format Painter Icon

share|improve this question
The words to describe the icon you selected is the format painter shortcut in excel. – user48927 May 8 '13 at 6:48

There is no official keyboard shortcut for that. But you can customize a shortcut. Here's how:

Go to Tools-> Customize Keyboard. Select "Edit" from categories. On the right hand side select "Formatting". Go to "Press new shortcut key" and type in a new shortcut. I used Command + Shift + v. And , click on "Add" . Close the window. All set. Now i can just use the normal copy ( Command + c) the cells from which i want to copy the formatting. Then go the cell where i want to paste the format and hit the keyboard shortcut (Command + Shift + v). BAM ! the format is copied.

share|improve this answer

There is (now) a predefined shortcut for this

  • To copy the format: CMD+SHFT+C
  • To paste the copied format: CMD+SHFT+V
share|improve this answer
up vote -1 down vote accepted

This article here gave a detail guide on how to solve this quickly.

share|improve this answer

Within Microsoft Office, one can use:

  • Cmd + Opt + c to copy format
  • Cmd + Opt + v to paste format
share|improve this answer

Your Answer


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.