Hi "LurfysMa",
You can use a macro and assign a shortcut key.
Pasting Formats, as in Format Painter (#painter)
http://www.mvps.org/dmcritchie/excel/paste.htm#painter
should satisfy the requirement to not write a macro if it already
exists.
To install the macro you find there see
http://www.mvps.org/dmcritchie/excel....htm#havemacro
To install the shortcut key Ctrl+Shift+P or other shortcut of your choice see
http://www.mvps.org/dmcritchie/excel...k.htm#shortcut
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"LurfysMa" wrote:
Is there a built-in keyboard shortcut for the Format Painter?