Using the "Find" tool (advanced)
And even more "Find" options...
In addition to what is taught in the video above, Find has several functions beyond a simple search tool. These can be accessed through the “Options” submenu in the "Find and Replace" dialog box.
For instance, you can choose to search only on the current sheet, or in the entire workbook. You can arrange the search by rows or by columns, and you can even search specifically in your formulas, values, and comments.
You can have Find look for the matching case as well, which is useful when searching names or other words with capital letters.
Find can even search through formatting. Click the “Format” button and you’ll see options allowing you to search by font type, size, background color, etc.
With all of these options available, you get a huge variety of ways to search and find your data.