Now to filter these cells, here are the steps: In the above steps, we have converted the bold text format into a format that is recognized as a filter criterion by Excel. This will color all the cells that have the text with bold font formatting.
In the Editing group, click on the Find and Select drop down.Here are the steps filter cells with bold text format: The idea is to find the bold font formatting in the worksheet and convert it into something that can be easily filtered (Hint: Cell color can be used as a filter). Method 1 – Filter Bold Cells Using Find and Replaceįind and Replace can be used to find specific text in the worksheet, as well as a specific format (such as cell color, font color, bold font, font color). Method 1 – Filter Bold Cells Using Find and Replace.
