When working with a large workbook or a sheet of dozens of columns and hundreds of rows.Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string.
When all else fails, you can use Excel Find feature to locate specific information in the worksheet. Choose Home→Find & Select→Find or press Ctrl+F, Shift+F5, or even Alt+HFDF to open the Find and Replace dialog box.
In the Find What drop-down box of this dialog box, enter the text or values you want to locate and then click the Find Next button or press Enter to start the search. Choose the Options button in the Find and Replace dialog box to expand the search options.
To access some more advanced find features in Excel, execute the following steps.
1. Click on Options in the ‘Find and Replace’ dialog box.
2. Type the text you want to find. For example, type Ferrari.
3. Select Workbook from the Within drop-down list to find occurrences across all the worksheets.
4. Checking “Match case” will make your search case-specific. For example, it will only find Ferrari and not ferrari.
5. Checking “Match entire cell contents’ will only find cells which contain exactly “Ferrari”. For example, cells that contain “Car Ferrari”, “Ferrarii” or even “Ferrari " will not be found.
6. A question mark (?) matches exactly one character. For example, F?rrari will find Ferrari, Forrari, Farrari, etc. An asterisk (_) matches a series of zero or more characters. For example, F_rrari will find Ferrari, Foorrari, Faaaaaarrari, etc.