How to Search within a Google Sheets

Posted by
How to search within a Google Sheet

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

  1. On your computer, open a spreadsheet in Google Sheets.

  2. Click EditFind and replace.

  3. 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.”

  4. To search for the word, click Find. To see the next time the word is used, click Find again.

  5. To replace the highlighted word, click Replace. To replace the word every time it’s used, click Replace all.

  6. 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

  1. 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.

  2. Tap More 더보기(iOS) or More(Android) and then Find and replace.

  3. Type the word you want to find.

  4. Tap Search.

  5. To see every time the word is used, in the top right, tap the arrows.

  6. 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.

  7. To return to the spreadsheet, tap Close Close(iOS) or tap Done