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.
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
There is (now) a predefined shortcut for this
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.
This article here gave a detail guide on how to solve this quickly.
Within Microsoft Office, one can use: