How to Filter All Cells by Bold Characters in Microsoft Excel 365?
Tags: filterallcellsbybold, kutools
Published: 2020-08-06 10:33:48

---
title: How to Filter All Cells by Bold Characters in Microsoft Excel 365?
published: true
date: 2020-08-01 05:25:02 UTC
tags: FilterAllCellsbyBold,Kutools
canonical_url: https://geekexcel.com/how-to-filter-all-cells-by-bold-characters-in-microsoft-excel-365/
---

## Filter All Cells by Bold Characters in Excel:

In this article, you will learn how to **Filter All Cells by Bold Characters in Excel** 365 using **Kutools**.

Kutools for Excel has many built-in functions to perform complicated tasks with several clicks. Here we are going to use one of the Kutools features that are **Special Filter** options to filter the cells by bold characters.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) But it has more than 120 features. They are used to solving more complicated tasks easily.


## Filters All Cells by Bold Characters in a Column:

To filter all cells by bold characters in a column, do as follows.

- You have to select any cell in the column in which you want to filter all cells by bold cells. On the **Kutools Plus** tab, select the **Special Filter** option, then **choose** the **Filter**  **Bold** option.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1.png)

- Then, the **Kutools for Excel dialog box** will pop out to show that how many cells are found in the list, click **Ok** to proceed.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2.png)

- Now, all the Bolded cells will be filtered out from the selected column like below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3.png)

## Filters All Cells by Bold Characters and Highlight with Specified Font or Background Color:

If you want to filter all cells by bold characters and highlight with specified font or background color, follow the below steps.

- On the **Kutools Plus** tab, select the **Special Filter** option, choose the **Special Filter** option from the menu.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/07/5-8.png)

- It will open the Special Filter dialog box, Select the finding range using the **Range** option.
- **Check** the **Format** option, select **Font Bold** option from the drop-down list under the **Filter rules** section.
- **Choose** the **Font** or **Background** Color as you need under the **Processing of results** section.
- Then, click the **Ok** button.

### Note:

You can select the filtered rows by checking the **Select entire row** option in the **Special Filter dialog box**.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4.png)

- After clicking the Ok button, **kutools for Excel dialog box** will pop out.
- Then, Hit the **Ok** button.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5.png)

- Thus, You will get the filtered bold cells with the selected font or background color will be displayed like below.

![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/6.png)

## Closure:

In this article, you can understand the steps to **Filter All Cells by Bold Characters in Excel** 365 using **Kutools**. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Filter Cells by Uppercase or Lowercase in Excel?](https://geekexcel.com/how-to-filter-cells-by-uppercase-or-lowercase-in-excel/)
- [Filter Merged Cells in Microsoft Excel 365](https://geekexcel.com/how-to-filter-merged-cells-in-microsoft-excel-365/)
- [How to Filter All Cells By Italics in Microsoft Excel 365?](https://geekexcel.com/how-to-filter-all-cells-by-italics-in-microsoft-excel-365/)