How To Search in Google Sheets

In this tutorial, you will learn how to search in Google Sheets.

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:

Step 1

Use the hotkey to bring up the Search Dialog:

  • Windows: Ctrl + f
  • Mac: ⌘ + f

Step 2

Type in the string you’re looking for and all cells containing that string will highlight in green

Step 3

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”

Step 4

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

Step 5

If the string you’re searching for is not found in the document, you will see “0 or 0” in the search field

Step 6

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.

Summary

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.