Introduction

Finding Members or Data Values


To find members or data values:

  1. Select Edit > Find... from the menu bar.
  2. Enter the complete or partial string or value you are looking for. You can also search by pattern using wildcards:
  3. Specify whether you want to search header cells, data cells, or both.
    By default, data cells searches are turned off. You can search the data cells as numeric values or as formatted text. Searching the data cells as formatted text allows you to look for specific formats such as commas (",") in data values, or when the data are text strings.
  4. Specify whether the search should be case-sensitive.
  5. Specify whether to search by row or column.
  6. Click Find Next.
    Matched cell is highlighted.
    Click Find Next to find the next match.

 

Related Topics: