FlexFind

Flexfind is an Excel add-in which allows you to search for strings in many parts of your workbook.

What makes Flexfind special is that it not only searches in worksheet cells. The current list of searched objects includes:

Cell formulas

Cell Values

Validation formulas

Conditional formatting formulas

Chart ranges

Chart titles (main title, axes titles)

Series labels

Shapes (their text value)

Worksheet headers and footers

Range names

Comments

Notes

Pivot table source ranges