Easy search - By text  

1. Include the active cell in the range to be searched.
2. Click on the Easy Search button in the toolbar.
The selected range is automatically detected as the search range.
If that is not the range to be searched, you may choose another manually.
3. Finally, decide which sheets contain the same range to be searched.

4. Now, choose the search mode. In this example, choose Search By Logic Criteria
Decide whether you want to search for a complete word or just a text contained in the word.
5. Finally, choose the cell containing the target text or enter directly the text, as in the example.

Once completed, decide what to do with the data, namely:
a. Select the cells meeting the criteria
b. Browse withing resulting cells
c. Print an Easy Search report.