Microsoft Excel - key combination for format painter in excel

Is there any key board combination for Format Painter in Excel.

So we can use with the keyboard without the help of a mouse.

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