Search a Spreadsheet for text, phrase, number, or characters
1. Open a Spreadsheet. In View mode, tap the menu in the top right.
2. Tap Find.
3. Type what you want to find. Optionally, tap the search filter criteria icon:
- 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.
- Look in: To search for data with specific details, in the box, tick Search in results of Formulas.
Find and Replace
1. Open a Spreadsheet. In Edit mode, on the Home tab, swipe the toolbar to reveal more options.
2. Tap Find & Replace. Optionally, tap the search filter criteria icon.
3. Type what you want to locate in the Find box.
4. Type your new text in the Replace box.
5. Tap Replace to replace the highlighted occurrence or tap All to replace all occurrences.