How to Find Cells with a Comment

When working with Excel, you may insert comments to different cells for future references. If you want to find all the cells with comments, please follow the steps below for details:

Step 1: Click anywhere in the worksheet;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Find & Select" in the "Editing" section;

Step 4: Click "Comments" from the drop-down list;

Step 5: You will see all the cells with comments.

Step 6: One disadvantage is that the selection will disappear when you click any cell again in the worksheet. You can highlight the cells for future references using "Fill color" from the "Home" tab. Cells with background color are easier to find after.

Leave a Reply