How to find data in a worksheet

If you are working with a large worksheet, you can use Discoverer's search facility to find data that matches a search term you specify. For example, to find cell values that contain New York.

To find data in a worksheet:

1. Display the worksheet that you want to search.

2. Choose Edit | Find to display the "Find dialog (in Worksheet)".

   
   Description of the illustration find.gif
   
   

3. Use the Search in and Search by drop down lists to specify search.

4. In the Search for field, enter the search text that you want to find.

5. Click Find Previous or Find Next.

   Note: The search starts from the currently highlighted worksheet cell (if a worksheet cell is highlighted) or the start of the worksheet.

   If the worksheet contains the search text that you specified, Discoverer highlights the first occurrence of this search term in the worksheet.

   
   Description of the illustration fiw.gif
   
   

   If the worksheet does not contain the search text that you specified, Discoverer displays a 'No match found' dialog.

6. (optional) Use the Find Previous and Find Next buttons to search for other occurrences of the search term.

   When the search reaches the end of the worksheet, Discoverer goes back to the start of the worksheet and resumes the search.

7. Click Close to close the "Find dialog (in Worksheet)".