How To Search In Google Sheets In 2022 (+ Examples)

Home » How To Search Google Spreadsheet » How To Search In Google Sheets In 2022 (+ Examples)

Maybe your like

Last Updated on August 7, 2021 by Jake Sheridan

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

How To Search In Google Sheets

  • How To Search In Google Sheets
  • Search for Text in a Google Spreadsheet
  • Searching Multiple Sheets of Your Spreadsheet
  • Summary

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.

You might also like:
22 Ways to Format Text in Google SheetsHow To Count How Many Times A Word Appears in Google SheetsHow To Change Text To All Caps In Google SheetsHow to Fit Text to Cell in Google Sheets

Tag » How To Search Google Spreadsheet