You can use Find to search something such as a number or text in your workbook. This feature is useful to quickly search specific number or text when you are checking data in large spreadsheet

How to use Find in Excel

Following this steps

1. at Home tab => go to Editing Group => then click Find & Select => click Find…

Find Text or Number in Worksheet

2. Find and Replace dialog will show up.

Find Text or Number in Worksheet

3. type text that you want to find in Find what box then click Find Next button. Excel will select the first cell that matches you text.

Or click dropdown in Find what for select recent search from list.

Find Text or Number in Worksheet

4. click Find All button for show all cells that matches you text.

Find Text or Number in Worksheet

Search in selected rows or columns only

Select rows or columns you want to search then click Find Next button.

Find Text or Number in Worksheet

Use wildcard characters ? and *

You can use wildcard characters for search such as ? and *

? (question mark) matches exactly one character.

* (asterisk) matches zero or more characters.

Search with All?n

Find Text or Number in Worksheet

Search with H??ry

Find Text or Number in Worksheet

Search with Fr*

Find Text or Number in Worksheet

Option>>

More option for you customize your search.

Find Text or Number in Worksheet

Within: select data for search within a Sheet or a Workbook.

Search: choose By Rows or By Columns.

Look in: specific details of your search Look in Formulas, Values, Notes or Comments.

Match case: check this for search with case-sensitive.

Match entire cell contents: Check this for search cells that contain just the text that in the Find what.