Activating Format Painter with a shortcut

[Joe1010]

Activating Format Painter with a shortcut
I’m using a lot the Format Painter button. Is there a way to set up a shortcut like Ctrl plus any button to activate the Format Painter (the same as Ctrl B to Bold fields, ctrl X to Cut etc), so I only need to click on the filed I want to have the same format?
Thanks

 

[fumei]

Not really, although I have no idea what filed (field?) you are talking about. Or even the relevance of a field.

However, you may want to use the keyboard shortcut for copying formatting. This is actually handier (I think) as you don't have to shift from the keyboard to using the mouse.

Ctrl-Shift-C copies the format of the Selection, or the current paragraph.

Ctrl-Shift-V pastes that format. Not the text. The format.

Not only that, but the format attributes are retained so you can select and go Ctrl-Shift-V as much as you want, as many times as you want. You can do whatever other actions you want, yadda yadda, and do another Ctrl-Shift-V. The copied format is retained for the entire Word session.

Until, of course you do another Ctrl-Shift-C.

That being said....ahem...IMO, using FormatPainter is to be avoided.

Use Styles. Styles are much better, and are the way Word is designed to be used.

I never use FormatPainter.

faq219-2884

Gerry
My paintings and sculpture

 

[PeterMoran]

Hi,

I use Excel 2K and Gerry's keystrokes of Ctrl+Shift+C and Ctrl+Shift+P don't work there.

However Ctrl+C copies and there is a Paste Formatting button which can be added which enables just the format details of the Copy to be Pasted. I can't see any way that a keystroke combination can be added to Toolbar buttons.

For what its worth I have three Paste buttons, Format(as above), Values(Toolbar button wich can be added) and Formulas(my own macro) which I use frequently and would not be without.

Good Luck!

Peter Moran

 

[GlennUK]

After doing Ctrl-C you could do Alt-E-S-T and then Enter. That does Edit/Paste Special/Formats. Assuming you are using Excel ( Gerry's reply is for Word, I would think ).

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Joe1010]

I’m using excel.
Alt-E-S-T and then Enter takes some time and I have a lot of formats to copy. Is there a way to create a macro with the function of Alt-E-S-T and enter?
Thanks

 

[kjv1611]

If you are at least a little comfortable using VBA, you can record 2 macros, then just edit the code in them to do whatever you want. With your macros, you can assign "hot key" combinations - Ctrl + another key for each. So, you could set up the two, something like this, maybe:

Just use <Ctrl> + <C> for copy, and then:

Private Sub CopyFormat()
  Selection.PasteSpecial
    Application.CutCopyMode = False
End Sub

And the Sub Name would be what you named the macro you recorded with the Macro Recorder, and assigned whatever key combination to it that you prefered.

Just make sure when recording the macro, you save it in the PERSONAL macro workbook if you want to be able to use this with any workbook you open.

Let me know if this doesn't make sense.

--

"If to err is human, then I must be some kind of human!" -Me

 

[fumei]

Joe1010, this is a very good reason why it is helpful when you post to say things like, oh...the application in mind?

I would not have posted the Ctrl-Shift-C if I knew it was not Word.

faq219-2884

Gerry
My paintings and sculpture

 

[Joe1010]

Yes it worked. The Macro is a bit deferent since I deal with merged fields.
Gerry, sorry and thanks for your help.
Does it make sense to split this group to the product level?

 

[fumei]

Does it make sense to split this group to the product level?

YES! In the sense that when anyone posts a question they state what application they are talking about. Action processes can be very different between the different Office applications. Knowing what application someone is asking about is VERY helpful.

The example above is, again, a good demonstration. If I had known it was for Excel I would not have posted a Word answer.

It is an informational thing. It helps to give us something to work with, and flags your posts (the generic "you") to people who are experts in that application. I am not an Excel expert. I leave serious Excel questions for the many Excel experts here.

The more clear information we have, the better. It may seem to be over-fussy, but clear information gets better, quicker, responses, as we can respond to the issue.

A common example is when people post questions about a "form", and also do not mention what application. Or even DO mention a "form". Say, a "form" in Word. That can mean a userform (in VBA), or a constructed design in a document. Unless the poster tells us, we don't know and have to start a process of trying to get the poster to tell us.

I am not be critical. I am simply stating that identification and clear descriptions help everybody.

faq219-2884

Gerry
My paintings and sculpture