Filter By Bold Text In Excel

This post demonstrates how we could filter data by bold font in excel, people sometime comments in bold to make it look more legible or highlight to draw attention quickly.We will see in this post how to apply filter by bold text in excel.

Let’s see how to filter by bold text font size in excel.

In our day to day office work, we often come across data that have columns having mixed font sizes and we need to apply filter on that font only.




We will see a simple example to see how we can filter by bold text font in excel.

Capture

Step 1

Press keyboard shortcut Ctrl+F to open Find toolbox in excel and go to Format as show below.

Capture

Step 2

Go to Font tab and select the Font Style by which you want to filter the data. As I would want to filter for bold text font in my data here so I have selected it as shown below and press OK.

Capture

You could also select any cell manually which has the same format by which you want to apply the filter by “Choose Format From Cell” option at the left bottom corner of the Find Format feature as shown in the picture above.

Step 3

Now you will get the window as shown below where you could see all the data that has the same format for which the filter was applied for.

Capture

Select all by pressing keyboard shortcut Ctrl+A.

Capture

Step 4

You could see the actual data in your column is highlighted now.

Capture

Now change the color of the selected cells to yellow or to any of your favourite color.




Capture

Step 5

Now Apply filter and filter by cell color as show below.

Capture

As you could see the data is filtered by your font formatting.

Capture

Hope this helped.



Share The Knowledge

Random Posts

Leave a Reply