You can always search within a Google Sheet file using the keyboard shortcut Ctrl + f (⌘ + f on a Mac). Here is a step by step guide on how to search within a Google Sheet using find and replace on different devices.
Use find and replace within a Google Sheets on your computer
- On your computer, open a spreadsheet in Google Sheets.
- Click Edit > Find and replace.
- Next to “Find,” type the word you want to find, If you want to replace the word, enter the new word next to “Replace with.”
- To search for the word, click Find. To see the next time the word is used, click Find again.
- To replace the highlighted word, click Replace. To replace the word every time it’s used, click Replace all.
- Narrow your search by using options below.
- Match case: Makes your search case-sensitive.
- Match entire cell contents: Searches for cells that are an exact match.
- Search using regular expressions: Searches for cells that match a pattern.
- Also, search within formulas: Searches include formulas.
Use Find and replace within a Google Sheets on your mobile
- On your iPhone or iPad, open a spreadsheet in the Google Sheets app, and on your Android phone or tablet, open a spreadsheet in the Google Sheets app.
- Tap More (iOS) or (Android) Find and replace.
- Type the word you want to find.
- Tap Search.
- To see every time the word is used, in the top right, tap the arrows.
- To replace the word, tap Replace with.
- To replace a single word, tap Replace.
- To replace every time the word is used, tap Replace All.
- To return to the spreadsheet, tap Close (iOS) or tap Done (Android).