Searching for text stored in cell comments (Excel 2000/2001/2002/2003/2007)

Excel's Find feature lets you easily locate cells containing a specific text string, but sometimes the information you're looking for is stored in cell comments, which aren't examined by default. However, you can configure the feature to look within cell comments for your search string. To do so, choose Edit | Find from the menu bar. (In Excel 2007, click the Find & Select button in the Home tab's Editing group and then choose Find from the dropdown list.) Then, if necessary, click the Options button to expand the dialog box. Finally, select Comments from the Look In dropdown list and finish performing your search as you normally would.