Blog

How to Filter Bold Text from the Column

How to Filter Bold Text from the Column

                                  

                                             Many times I received the query from our excel users asking how to filter the text with bold character, but unfortunately, there is no direct way in the filter option



So here we provide a small trick to filter the bold text only by using Find option.

 

Step-1

Press Ctrl+F Key or Find option and click on the Format option, and click on Font option and select bold and press ok

Click on the Find All option, Now select the area which is having bold character by typing Ctrl+A





Step-2

 

And fill the selected cells with color, Filter the column with color


 

Step-3

Copy the text and paste it in the other column.

 

 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.