GuidesGoogle Sheets

How to search for words in Google Sheets

Learn how to search for words in Google Sheets using Find and Replace, keyboard shortcuts, and search functions to quickly locate data.

Quick answer

Press Ctrl+F (Cmd+F on Mac) to open the search box, then type the word you want to find. Google Sheets highlights every matching cell instantly. For more control, use Ctrl+H to open Find and Replace, which lets you search within specific sheets, match case, or replace found words with new text.

Steps at a glance

  1. Press Ctrl+F (Cmd+F on Mac) to open the search box
  2. Type the word or phrase you're looking for
  3. Use the arrows to jump between matches
  4. Press Ctrl+H to open Find and Replace for advanced options
  5. Choose to search the current sheet, all sheets, or a range
  6. Click Replace all if you need to swap matched words
  7. Use SEARCH or FIND formulas for conditional lookups

Summary

Google Sheets includes several built-in ways to search for words, from a quick keyboard shortcut to the more powerful Find and Replace dialog. These tools help you locate exact matches, swap text across a range, or build formulas that search cell contents automatically.

Step-by-step guide

  1. Step 1

    Open the search box with a keyboard shortcut

    Click anywhere inside your spreadsheet, then press Ctrl+F on Windows or Cmd+F on Mac. A small search bar appears in the top-right corner of the sheet, ready for you to type your query.

  2. Step 2

    Type your search term

    Enter the word or phrase you're looking for into the search bar. Google Sheets highlights every cell containing a match in yellow and shows how many results were found, updating live as you type.

  3. Step 3

    Navigate between matches

    Use the up and down arrows next to the search box to move through each matching cell one at a time. This is especially useful in large sheets where you've already applied a filter to narrow down data and want to confirm specific entries.

  4. Step 4

    Open Find and Replace for more control

    Press Ctrl+H (Cmd+Shift+H on Mac) or go to Edit > Find and replace. This dialog lets you search with options like matching case, matching the entire cell content, or searching using regular expressions.

  5. Step 5

    Choose where to search

    In the Find and Replace dialog, use the 'Search' dropdown to limit your query to the current sheet, all sheets in the file, or a specific range you select manually. This keeps results focused when your file has multiple tabs, similar to how you'd scope a sort across a table to just the relevant columns.

  6. Step 6

    Replace matched words if needed

    Type your replacement text into the 'Replace with' field, then click Replace all to update every match at once, or Replace to confirm each one individually. Review the confirmation message showing how many replacements were made before closing the dialog.

  7. Step 7

    Search with formulas for dynamic results

    For ongoing or conditional searches, use formulas like =SEARCH("word", A1) or =FIND("word", A1) in a helper column to flag cells containing your target text. This approach works well alongside a custom filter setup when you want to isolate matching rows automatically.

Why this matters

You're staring down a spreadsheet with thousands of rows and need one customer name, product code, or comment fast. Instead of scrolling endlessly, you use Google Sheets' search tools to jump straight to matches, fix typos in bulk, or confirm a word appears nowhere else in your data.

Frequently asked questions

  • What's the fastest way to search in Google Sheets?

    Press Ctrl+F (Cmd+F on Mac) to open the quick search bar. It highlights matches instantly and lets you cycle through them without opening any additional menus.

  • Can I search for a word and replace it everywhere at once?

    Yes. Open Find and Replace with Ctrl+H, type your search term and replacement text, then click Replace all to update every matching cell in the selected search scope.

  • Does Google Sheets search work across multiple tabs?

    Yes. In the Find and Replace dialog, set the 'Search' option to 'All sheets' to check every tab in the file instead of just the one you're currently viewing.

  • Can I search using a formula instead of the search bar?

    Yes. Functions like SEARCH and FIND let you check whether a cell contains specific text and return its position, which is useful for building flags or filters based on search results.

Related guides

Create interactive demos like this one — free, no coding required.

Start for free →