Selecting needed format

[Sir]

How one can select and copy only the text with the chosen format ?

 

[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

 

[Sir]

How to select all the text with certain font (bold, italic and so on) in the
all cells ?

 

[Bob I]

Find, Options, Format

 

[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

 

[Alur]

Dear Bob.
Thank you for your answer:

Find, Options, Format

It's very helpfull.
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 ?

 

[Alur]

Thank you.