8

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

  • The words to describe the icon you selected is the format painter shortcut in excel. – user48927 May 8 '13 at 6:48
5

There is (now) a predefined shortcut for this

  • To copy the format: CMD+SHFT+C
  • To paste the copied format: CMD+SHFT+V
4

There is no official keyboard shortcut for that. But you can customize a shortcut. Here's how: http://thelostgeeks.blogspot.com/2012/10/keyboard-shortcut-to-copypaste.html

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.

-1

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

http://thelostgeeks.blogspot.com/2012/10/keyboard-shortcut-to-copypaste.html

-1

Within Microsoft Office, one can use:

  • Cmd + Opt + c to copy format
  • Cmd + Opt + v to paste format

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .