How to Filter Bold Cells Character Formatting in Excel

You can easily apply bold font character formatting in Excel, but you have to face lot of issue when you try to filter bold cells only. In this guide we have to discuss an easy trick which allows you to filter bold cells character formatting in Excel.

Lot of peoples have to face this type of situation and they have no choice how to deal with this situation. If you have a huge set of data and want to filter only highlighted bold cells on which apply character formatting in Excel. If you want to use filter command to do this job, then there is no choice. You have to waste lot of time to get the proper result.

How to Filter Bold Cells Character Formatting in Excel

If you want to filter bold cells character formatting in Excel with the help of Find and Replace command. All we know Find command is used to find the specific characters or words. You can use Replace command to find and replace the characters as as per your need. Now, you have to take given steps which helps you to filter bold cells character formatting in Excel.

Step 3: By default there is “No Format Set” option is already set at Find what box. Now, Click on the Choose Format From Cell… and choose formatted cell in-front of Find what box. You can check there is “Preview*” is shown at the place of “No Format Set”.