Sunday, December 19, 2010

How to search in comments

Here are the cells with comments I want to search.
 

The data range here is small, so you can search each comment manually by pointing your mouse to cell with comments.

However, there is much better way of searching comments by

1. Typing Ctrl+F and following instructions are self explanatory



2. Now you can select all cells by clicking on first cell in Find dialog box.



and then press Shift+End to select all.



OR

2. Hold Ctrl and then click on cell you want to highlight



3. Once the cells are selected you can hightlight it with
Fill Color button.


Note: We can only find comments and not replace any text in them.

No comments:

Post a Comment