Find dialog (in Worksheet)

Use this dialog to find data in the currently displayed worksheet. This is useful in large worksheets. For example, to find cell values that contain New York.

For more information, see:

"What are worksheets?"

"How to find data in a worksheet"

Search in

Use this drop down list to specify which worksheet area you want to search (for example, worksheet headings or worksheet data), as follows:

  • Select the Data only option to search the worksheet cell values (that is, data points), but not heading values in the left and top axes.

  • Select the Both data and heading option to search both the worksheet cell values (that is, data points) and the heading values in the left and top axes.

Note: This drop down list is only enabled on crosstab worksheets. On table worksheets, you can only search worksheet data.

Search by

Use this drop down list to specify how you want to match search text. For example, choose Contains here and type New York in the Search for field to find worksheet values containing New York.

Note: If you choose the Is Null option, you search for null values regardless of how null values are displayed. To specify how null values are displayed, choose Tools | Options, display the "Options dialog: Sheet tab", and select an option in the Show null values as field.

Search for

Use this field to enter the search text you want to find. For example, type New York here and choose Contains in the Search by drop down list to find worksheet values containing New York.

Note: This field is not enabled if you choose the Is Null option from the Search by drop down list.

Case-sensitive

Use this check box to specify whether you want to match upper and lowercase letters exactly when searching (for example, when selected, the search term 'New York' would find 'New York', but would not find 'NEW YORK', 'new york', or 'new York').

Find Previous

Use this button to search backward for the specified text. When the search reaches the beginning of the worksheet, Discoverer goes back to the end of the worksheet and resumes the search.

Find Next

Use this button to search forwards for the specified text. When the search reaches the end of the worksheet, Discoverer goes back to the start of the worksheet and resumes the search.

Notes

  • You can only search worksheet data that is currently displayed. A worksheet search does not include:

    • other page items (if specified).

    • data not yet displayed (for example, because Discoverer only data specified number of rows at a time). To change the number of rows retrieved at a time, choose Tools | Options, display the "Options dialog: Query Governor tab", and specify a value in the Retrieve data incrementally in groups of field.