To find cells containing a search string:
-
Click
on the Standard toolbar.
-
Beside Find What, type the text you want to search for.
Note: If there is an item selected in the worksheet, the Search Selected Cells will be checked by default. -
Select the Direction of the search: up or down.
-
Click Find Next.
Worksheet puts the cursor on the cell containing the text you entered. -
To search for the same text again using the same search direction, press f3.
Note: To reuse a previous search string, use Quick Find on the Standard toolbar . You can also search for a string by entering a value here.
Related articles