View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default Format Painter shortcut?

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?