Last Updated on August 7, 2021 by Jake Sheridan
How To Search In Google Sheets
If you have a lot of data in a Google Spreadsheet, it can be hard to find what you’re looking for.
Fortunately Google Sheets has a built-in search option that allows you to find the exact text you’re looking for every time it appears in your spreadsheet.
Search for Text in a Google Spreadsheet
Instead of reading through all the data in your spreadsheet manually, you can bring up the search dialog to quickly find the exact string you’re looking for.
To do this:
Use the hotkey to bring up the Search Dialog:
- Windows: Ctrl + f
- Mac: ⌘ + f
Type in the string you’re looking for and all cells containing that string will highlight in green
The number of times the search string was found will appear in the search field. For example, if your string appears 3 times in the document, it might say “1 of 3”
If the string appears more than once in your spreadsheet, use the up and down arrows to the right of the search box to step through all the cells in your spreadsheet that contain the search string
If the string you’re searching for is not found in the document, you will see “0 or 0” in the search field
Once you’re done searching your document, click the X at the right of the Search dialog. All the green highlights will disappear.
Searching Multiple Sheets of Your Spreadsheet
Note that the Search Dialog only searches the currently active sheet in your spreadsheet.
If you need to search an additional sheet, simply activate that sheet by clicking on the sheet’s name at the bottom of the window, then repeat the above steps.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to search in Google Sheets. Want more? Check out all the Google Sheets Tutorials.