How to Filter All Cells with Comments By Using Only One Click in a Selected Column?
Tags: filterallcellswithco, kutools
Published: 2020-08-06 10:32:34

---
title: How to Filter All Cells with Comments By Using Only One Click in a Selected Column?
published: true
date: 2020-08-01 07:42:19 UTC
tags: FilterAllCellswithCo,Kutools
canonical_url: https://geekexcel.com/how-to-filter-all-cells-with-comments-by-using-only-one-click-in-a-selected-column/
---

## Filter All Cells with Comments By Using Only One Click in a Selected Column:

In this article, we are going to see how to **Filter All Cells with Comments By Using Only One Click in a Selected Column in Excel** 365 using **Kutools**.

Kutools has a special function of the **Filter Comment** option, it will make our work simple. Let’s get into this article and see the steps.

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) is a third party plugin. You have to install it before use this.


## **How to Filter All Cells with Comments in a Selected Column in Excel?**

Let’s see the below instructions to filter all cells with comments in a selected column in Excel.

- You need to select a column that contains cells with comments to be filtered, On the **Kutools Plus** tab, select the **Special Filter** option, Choose **Filter Note** option from the menu.

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

- Then, **Kutools for Excel dialog box** will pop out to tell you how many cells have been found with the notes, click the **Ok** button.

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

- Then, the filtered cells with comments will be displayed in the worksheet as below image.

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

## **How to Filter All Cells with Comments and Fill with Font or Background Color in Excel?**

To filter all cells with comments and fill with font or background color in Excel, do as follows.

- Select a column that contains cells with comments to be filtered, On the **Kutools Plus** tab, select the **Special Filter** option, Choose **Special Filter** option from the menu.

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

- In the **Special Filter Dialog box** , select the **Format** option under the **Filter rules** section.
- **Choose Comments** from the drop-down list.
- **Select the Background** or **font** color from the **Processing of result** section.
- Then, click the **Ok** button.

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

- Now, the **Kutools for Excel dialog box** will be popped out to remind you of the total number of comments cells.
- Then, Hit the **Ok** button.

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

- Thus, all the comments cells will be displayed with the **specified font or background color** like the below example.

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

## **Wind-Up:**

In this article, you can easily understand the steps to **Filter All Cells with Comments By Using Only One Click in a Selected Column in Excel** 365 using **Kutools**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to change Cell Background Color in Microsoft Excel 2007?](https://geekexcel.com/how-to-change-cell-background-color-in-microsoft-excel-2007/)
- [Vlookup Values From Right and Return Results in the Left Column in Excel](https://geekexcel.com/how-to-vlookup-values-from-right-and-return-results-in-the-left-column-in-excel/)
- [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/)