T
tralfaz113
Can Formatting Painter be used to format multiple rows withiout having to hit
the Painter Icon multiple times? Thank you! - rms
the Painter Icon multiple times? Thank you! - rms
Format Painter:Can it repeat w/out having to hit icon multi times
B
Bob I
Drag the cursor down the rows to be formatted before releasing the mouse
button.
button.
T
tralfaz113
Sorry I left out a factor. I am formatting 12,000 lines of data wherein the
last 3 lines of each horzontal group has to be formatted the same way. These
lines are not adjacent to one another. I hope this is clearer. Thank you
very much for your earlier very prompt response, Bob!!!
last 3 lines of each horzontal group has to be formatted the same way. These
lines are not adjacent to one another. I hope this is clearer. Thank you
very much for your earlier very prompt response, Bob!!!
B
BoniM
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.
turn it on for multiple uses. Click it again or hit Esc to turn it off when
you're finished.
T
tralfaz113
HI BoniM! You ROCK - thank you so much for your help!! You've made a very
tedious, mind-numbing job so much easier! It works PERFECTLY! Have a great
weekend
tedious, mind-numbing job so much easier! It works PERFECTLY! Have a great
weekend
B
BoniM
You are very welcome - happy to help - thanx for the feedback - and may your
weekend be fantabulous as well... for some reason I'm thinking a little
Guitar Hero would be good now
weekend be fantabulous as well... for some reason I'm thinking a little
Guitar Hero would be good now
J
Jan
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.
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.
B
BoniM
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. :-(
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. :-(