Find Data

Use the Find window to search for data. You can search for data within a column, entire table, or selection.

1. From the Searching group of the Home tab, click Find.

2. Type the data you want to look for in the Find box.

   If you are searching in a column that has checkboxes, use only true or false in the Find box. (The search is not case sensitive.)

3. In the Look In list, select a region of the table to search. You can search a column, the text you have selected, or the entire table.

4. In the Match list, select how the search text must compare to table cells.

   Click Start of Field to find text that appears only at the beginning of a cell.

   Click End of Field to find text that appears only at the end of a cell.

   Click Part of Field to find text that appears anywhere in a cell.

   Click Whole Field to find text that exactly matches cell contents.

   Note: If you are searching a column that includes checkboxes, the program always searches the whole field, regardless of your entry for the Match field.

5. Select the Match Case checkbox to find only text that matches the capitalization of the text you entered in the Find box.
6. Click [Find Next] to find the next occurrence of the text.