Filter A List By Font In #Excel

Here is a way to filter a list by the font of certain entries:

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

I have a list of contestants where the names are in Arial 12 pt. bold, and the addresses are in Calibri 11 pt. not bold. I want to filter the list so I can just see the names:

fbf1

There is no filtering option in the standard Filter process in Excel (located on the Data tab in the Sort & Filter group) to filter by font, so we are going to have to do this in multiple steps.

First, I will highlight the list, excluding the header, and use the keyboard shortcut Ctrl F to open the Find dialog box, and click on Options:

fbf2

Click on Format and then enter the specifics about the format by which you want to filter:

fbf3

Click OK. Now click on Find All, then use the keyboard shortcut Ctrl A to select all of the cells that meet that criteria:

fbf4

You will see that Excel has selected each cell that meets the format you defined. Now, close the Find box, and choose a color to highlight the selected cells:

fbf5

At this point, you can now activate the Filter option, and then choose to filter by color:

fbf6

And you now have a filtered list by the specified format:

fbf7

Piece of cake (hmmm, that makes me hungry)!

Happy Excelling!

Related Post

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

, , , , ,

2 Responses to Filter A List By Font In #Excel

  1. THANKS! June 19, 2014 at 2:34 am #

    Thank you so much! I wish I found your post before I spent 2 hours trying to google how to do this in a macro.

Leave a Reply