Find Text

To find text within a grid, enter the string to be searched for in the field in the Find & Replace section of the Home Tab and either click Next or the button with the magnifying glass symbol next to the field. The first row that contains a match is then highlighted and the cell that contains the match is selected.

Click Next or the button again the find the next match. Click Previous to select previous matches for the current search.

If no matches are found, a message is displayed to inform the user of this.

The drop-down list in the field lists all the strings searched for in the current sessions.

Alternatively:

1. Click Find in the Find & Replace section of the Home Tab. The Find and Replace window is then displayed:

   

2. Enter the string that is to be searched for in the Find What field. If the string has already been searched for during this session, it can be selected from the drop down list accessible from this field.

3. Click Options >> if a more refined search is required. Additional fields are then displayed in the window:

   

4. From the Within drop down list, select which columns are to be searched. By default, all columns are searched, but a single grid column can be selected if required.

5. From the Search drop down list, select the direction in which the search will take place: All (i.e. up and down - default), Up, or Down.

6. From the Match drop down list, select the matching criteria for the search: Partial Match - Contains (default), Partial Match - Begins With, Partial Match - Ends With, or Complete Match.

7. Check Match Case if only text in the grid that matches the case of the text entered in the Find What field is to be found. Unchecked by default.

8. To proceed with the search, click Find Next.

9. The first row that contains a match is then highlighted and the cell that contains the match is selected.

10. Click Find Next again to find the next match.

11. If no matches are found, a message is displayed to inform the user of this.

12. Click Close to exit the window.