View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
BoniM BoniM is offline
external usenet poster
 
Posts: 353
Default Format Painter:Can it repeat w/out having to hit icon multi ti

If it is the same word that you want to format differently... check out the
Replace options. That would be even easier. You can use it to replace the
word with the word formatted differently. Click the Options button, if
necessary, to see those choices.
Is it a single word in a cell or a single word within other text in a cell?
Format painter can't be used if it's the second. :-(

"Jan" wrote:

I tried that it doesn't wotk even though that's the way it's supposed to
work. I need to repeat the formatting of one word throughout my document. I
select the word I want to repeat double click on the format painter and
select the word to change but then I go to the next word to be changed and I
have to click on the format painter again. I know I double clicked but I
can't get it to stay on. Extrememly frustrating.

"BoniM" wrote:

Double click the format painter button instead of clicking once and it will
turn it on for multiple uses. Click it again or hit Esc to turn it off when
you're finished.

"tralfaz113" wrote:

Can Formatting Painter be used to format multiple rows withiout having to hit
the Painter Icon multiple times? Thank you! - rms