Search a spreadsheet Windows
Search a spreadsheet for text, phrase, number, or characters
1. Open a spreadsheet. Press CTRL+F, or
In the Edit tab, select Find & Replace.
2. In the popup dialog, in the Find tab, type what you want to find.
3. Optionally, check the search filter criteria box:
- Match case. Finds only occurrences of the text that match the capitalization you type.
- Match entire cell. Search for that contain just the characters that you typed in the Find what: box.
- Search within: To search for data in a worksheet or in an entire workbook, select Current Sheet or Entire Workbook.
- Look in: To search for data with specific details, in the box, click Formulas, Values.
4. Press Enter or navigate the highlighted search results with the Find Next and Find Previous buttons.
Find and Replace
1. Press CTRL+F, or
In the Edit tab, select Find & Replace.
2. In the popup dialog, in the Replace tab, type the word or number you want to locate in the Find box.
3. Type your new text in the Replace box.
4. Optionally, check the search filter criteria box.
5. Click Replace to replace the highlighted occurance, or click Replace All to replace all occurances.