Find
This option can be used to find a specific value or text within a worksheet.
To use this, click on the Find and Select option on the Home tab and choose Find from the drop down list.
This will bring up the following screen:
The value or text to be located should be entered into the Find What box. The user then has the option to find all occurrences within the spreadsheet by using the Find All option or to go through and find each one individually by using the Find Next option.