Format Painter shortcut?

[LurfysMa]

Is there a built-in keyboard shortcut for the Format Painter?

If not, is there a way to to assign to some key combination? I know I
can assign a key combination to a macro, but I would prefer not to
write a macro just to get a keyboard shortcut for a standard function.

Thanks

 

[Guest]

i don't know of any but you could copy the cell with the correct paste
special>formats and then use F4 to repeat the action in each cell you want to
format

 

[David McRitchie]

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/getstarted.htm#havemacro
To install the shortcut key Ctrl+Shift+P or other shortcut of your choice see
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#shortcut

 

[Nathan Larson]

I wish there were a built-in keyboard shortcut for the format painter in Excel. There is one in Word - just highlight some text, use Ctrl-Shift-C to copy the format, highlight the text whose format you want to change, and then use Ctrl-Shift-V to paste it. I tried it in Excel but it didn't work.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Ron de Bruin]

Hi Nathan

You can create your own macro with this code line

Application.CommandBars("Standard").FindControl(ID:=108).Execute

Assign the shortcut you want to it


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


in message news:[email protected]...

 

[Ron de Bruin]

You can add the macro to your personal.xls so you can use it in all your workbooks
http://www.rondebruin.nl/personal.htm

 

[David McRitchie]

Of course there is already a Ctrl+Shift+C and Ctrl+Shift+V
so you'd want to make sure you don't mind losing them
http://www.mvps.org/dmcritchie/excel/shortx2k.htm
In other words all the good shortcuts are taken.

You might take a look at
http://www.mvps.org/dmcritchie/excel/paste.htm#painter

Which uses your normal Ctrl+C and you add a Ctrl+Shift+P
as in (Format) Painter.