You can search for text strings in the cells, tags, or formulas. You can specify the case, use wildcards, and specify a range of cells to search in.
For more information, see Searching Data.