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

--
Running Excel 2000 SP-3 on Windows 2000

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

"LurfysMa" wrote:

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

--
Running Excel 2000 SP-3 on Windows 2000

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?

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

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


"Nathan Larson" wrote in message ...
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

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

--

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


"Ron de Bruin" wrote in message ...
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


"Nathan Larson" wrote in message ...
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

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.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Ron de Bruin" wrote in message
...
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


"Nathan Larson" wrote in message
...
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