S
Sir
How one can select and copy only the text with the chosen format ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi
the copy command pretty much copies everything but the paste command has a
number of options available.
in your case i'm guessing that you want to paste special values. this would
paste only the text and leave the previouse cell's formating behind.
regards
FSt1
the copy command pretty much copies everything but the paste command has a
number of options available.
in your case i'm guessing that you want to paste special values. this would
paste only the text and leave the previouse cell's formating behind.
regards
FSt1
S
Sir
How to select all the text with certain font (bold, italic and so on) in the
all cells ?
all cells ?
B
Bob I
Find, Options, Format
G
Gord Dibben
If all text in the cell is a certain format see Bob's second reply.
If a mixture, you would need VBA
Gord Dibben MS Excel MVP
If a mixture, you would need VBA
Gord Dibben MS Excel MVP
A
Alur
Dear Bob.
Thank you for your answer:
But you can get them one by one (one at a time).
I would like to select all at once to copy them and paste in the another
sheet. There are many information, so selecting one at a time will take so
much time, that is not desirable method.
How to select all the text with certain font (bold, italic and so on) in the
all cells at once ?
Thank you for your answer:
It's very helpfull.Find, Options, Format
But you can get them one by one (one at a time).
I would like to select all at once to copy them and paste in the another
sheet. There are many information, so selecting one at a time will take so
much time, that is not desirable method.
How to select all the text with certain font (bold, italic and so on) in the
all cells at once ?
A
Alur
Thank you.