Finding Data in a Spreadsheet

To find data in a spreadsheet:

  1. Select the column you want to search in.
  2. In the Database Manager, in Ribbon view, on the Home tab, in the Edit group, click Find.

- Or -

In Classic view, on the Database Manager's toolbar, click Find.

The Find dialog box appears.

  1. In the Find What field, enter the text you want to locate.
  2. Select the Match Case check box to do a case sensitive search. Otherwise, clear it.
  3. Select the Match Whole Words Only check box to locate only whole words that match the search string. Clear the check box to locate partial words.
  4. Click Find Next.
  5. Repeat step 6 to locate subsequent occurrences of the specified text.