Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string.
Find
To find something, press Ctrl+F, or go to Home > Editing > Find & Select > Find.
Editing Feature
1. In the Find what box, type the text or numbers you want to find, or select the arrow in the Find what box, and then select a recent search item from the list.
Find
2. Select Find All or Find Next to run your search.
Find All and Find Next
3. Select Options>> to further define your search if needed:
Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.
Options
Search: You can choose to search either By Rows (default), or By Columns.
Search By Rows or Columns
Look in: To search for data with specific details, in the box, select Formulas, Values, or Comments.
Formulas Values Comments
Match case- Check this if you want to search for case-sensitive data.
Match Case
Match entire cell contents - Check this if you want to search for cells that contain only the characters that you typed in the Find what box.
Match entire cell contents
4. If you want to search for text or numbers with specific formatting, select Format, and then make your selections in the Find Format dialog box.
Format Dialog Box
Replace
To replace text or numbers, press Ctrl+H, or go to Home > Editing > Find & Select > Replace.
Replace
1. In the Find what box, type the text or numbers you want to find, or select the arrow in the Find whatbox, and then select a recent search item from the list.
Find What
2. In the Replace with box, enter the text or numbers you want to use to replace the search text.
3. Select Replace All or Replace.
Replace and Replace All
4. Select Options>> to further define your search if needed:
Within: To search for data in a worksheet or in an entire workbook, select Sheet or Workbook.
Options Search: You can choose to search either By Rows (default), or By Columns.
Search by Rows
Look in: To search for data with specific details, in the box, select Formulas.
Formulas
Match case - Check this if you want to search for case-sensitive data.
Check Match case
Match entire cell contents - Check this if you want to search for cells that contain only the characters that you typed in the Find what box.
Match entire
5. If you want to search for text or numbers with specific formatting, select Format, and then make your selections in the Find Format dialog box.
Format Dialog box