Microsoft Excel - key combination for format painter in excel

Asked By BIMAL RATHORE on 09-Feb-13 04:29 AM
Is there any key board combination for Format Painter in Excel.

So we can use with the keyboard without the help of a mouse.
Pete Bradshaw replied to BIMAL RATHORE on 11-Feb-13 03:54 AM
Hi Bimal,

I'm not aware of any shortcut that will do this directly, but I use the Ctrl & C to copy, followed by Alt, E, S, T enter.

Alt followed by E brings up the Edit menu, S selects the paste special option, T selects the fomats option, and Enter will paste the formats only.

You can probably code this and add it to a custom addin, but I don't think it's worth the hassle.

Cheers

Pete