close
650x300x00_lead_image_search_comments_excel.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.FOG3c-trL5

Comments in Excel is a nifty little feature which helps you keep track of your work. But if you’ve added lots of comments it becomes difficult to remember which comment was where.

However, you can search through only the comments in your worksheet or workbook, with this advanced setting.

You can start the search from any cell in your worksheet. Excel will continue to cycle the search through the worksheet and search all the cells. Press Ctrl+F on your to open the dialog box with the Find tab active. Click “Options”.

443x194x01_clicking_options.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.1h7unruGAE

To narrow the search to only comments, select “Comments” from the “Look in” drop-down list.

452x243x02_selecting_comments.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.IrFiM7keBf

By default, Excel will only search the current worksheet. If you want to search through all the comments on all the worksheets in your workbook, select “Workbook” from the “Within” drop-down list. Click “Find Next” to start the search.

452x243x03_clicking_find_next.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.m4cg5RRasi

The first cell with a comment attached to it that contains the search term you entered is highlighted. The comment is not automatically shown. However, you don’t have to close the Find and Replace dialog box to view or edit the comment on the selected cell. The Find and Replace dialog box is a non-modal dialog box, which means you can work on the worksheet behind it while the dialog box is still open. If your comments are hidden, move your mouse over the selected cell to view the comment.

650x314x04_comment_found.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.WiTnFUQDAW

To edit, right-click on the cell and press “Edit Comment” from the pop down .

650x517x05_selecting_edit_comment.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.1t80fo9yh7

The comment is shown (if it was hidden) and the cursor is placed within the comment, allowing you to edit it. When you’re finished editing the comment, click in any other cell. Your changes to the comment are saved and the comment is hidden again, if it was previously hidden.

650x314x06_editing_a_comment.png.pagespeed.gp+jp+jw+pj+js+rj+rp+rw+ri+cp+md.ic.fbLTFT4hT3

To continue searching through your comments, click “Find Next” again on the Find and Replace dialog box to find the next occurrence of your search term. When you’re finished with your search, click “Close” to close the Find and Replace dialog box.

Tags : windowswindows how to
Nooruddin Ahmed

The author Nooruddin Ahmed

An avid football fan. Lives for the weekend game.Aviation enthusiast. Believes in letting bygones be bygones.

Leave a Response