Navigate to Specific Cell Content

1. Click Home > Find & Select > Find, and a Find and Replace dialog box will pop out. Input the text that you need in the Find what dropdown list. See screenshot:

2. Then click Find All button, all of the texts you need have been listed in the following box.

3. And then press Ctrl + A to select all of the values in the box. Click Close button, all of the text that you need have been selected in the range. Seen screenshots: