How to search in Google Sheets

Learn how to search for text, numbers, or formulas in Google Sheets using Ctrl+F to find matches and Ctrl+H to replace them.

Quick answer

To search in Google Sheets, press Ctrl+F (Cmd+F on Mac) to open the search bar and type your query. The matching cells are highlighted. For more options including replace, use Ctrl+H (Cmd+H) to open Find and Replace.

Steps at a glance

  1. Press Ctrl+F (or Cmd+F on Mac) to open the search bar.
  2. Type the text or number you want to find.
  3. Press Enter to jump to the next match.
  4. Press the up/down arrows in the search bar to move between matches.
  5. Press Escape to close the search bar when done.

Interactive demo

Loading demo…

This interactive demo was created free with Arclet in 2 minutes.

Create your own demo →Compare demo tools

Summary

Google Sheets has two search tools. The quick search bar (Ctrl+F) finds and steps through matches on the current sheet. Find and replace (Ctrl+H) has the options: all sheets or a specific range, match case, match entire cell contents, regular expressions, and searching inside formulas. To pull matching rows out rather than just jump to them, use a filter or a formula such as FILTER instead.

Step-by-step guide

  1. Step 1

    Open the search bar

    Press Ctrl+F on Windows or Cmd+F on Mac. A search bar appears in the top-right corner of the sheet.

  2. Step 2

    Type your search term

    Type the text, number, or part of a formula you want to find. Matching cells are highlighted on the sheet as you type.

  3. Step 3

    Navigate between matches

    Press Enter or click the down arrow in the search bar to jump to the next match. Press Shift+Enter or the up arrow to go to the previous match. The count shows how many matches were found.

  4. Step 4

    Search across all sheets

    To search every sheet in the workbook, open Find and Replace with Ctrl+H. In the Search dropdown, switch from This sheet to All sheets, or choose Specific range to limit the search to one column.

Why this matters

You're looking for a specific row in a spreadsheet with hundreds of entries — a customer name, a product SKU, or a transaction — and scrolling through everything to find it isn't an option.

Troubleshooting

  • Search is not finding text I can see on screen

    Check if the text is inside a formula rather than a displayed value. In Find and Replace, check Also search within formulas to include formula text in the search.

  • Matches are not highlighted

    Make sure you are searching in the active sheet. If the match is on a different sheet, the search will jump there automatically — check if the sheet tab changed.

  • Ctrl+F opened the browser's find bar instead

    The browser search only finds cells currently drawn on screen, so it misses most of a large sheet. Click any cell so the sheet has focus, then press Ctrl+F (Cmd+F) again to open the Sheets search bar.

  • Searching for 12 also finds 112 and 1200

    Search matches part of a cell by default. In Find and replace, tick Match entire cell contents to find only cells whose whole value is 12.

  • I need every cell that matches a pattern, like an email address

    In Find and replace, tick Search using regular expressions and enter a pattern, for example @example\.com$ for addresses at one domain.

Frequently asked questions

  • Can I search for a specific format in Google Sheets?

    The standard search does not filter by cell format. To find cells with a specific format, use Format > Conditional formatting to highlight them, or filter by color using Data > Create a filter.

  • Is the Google Sheets search case-sensitive?

    The default search is case-insensitive. To match case exactly, open Find and Replace and check Match case before searching.

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

Start for free →