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
- Press Ctrl+F (or Cmd+F on Mac) to open the search bar.
- Type the text or number you want to find.
- Press Enter to jump to the next match.
- Press the up/down arrows in the search bar to move between matches.
- Press Escape to close the search bar when done.
Interactive demo
This interactive demo was created free with Arclet in 2 minutes.
Create your own demo →Compare demo toolsSummary
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
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.
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.
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.
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.
Related guides
Continue with more step-by-step guides for getting work done.
How to create a filter in Google SheetsLearn how to create a filter in Google Sheets to sort, hide, and analyze data quickly using the built-in filter tool on any free account.
How to find duplicates in Google SheetsLearn how to find and highlight duplicate entries in Google Sheets using conditional formatting and COUNTIF formulas.
How to sort a table A–Z in Google SheetsSort a table in Google Sheets A to Z or by several columns without scrambling rows. Keep the header in place, or sort with a formula instead.
How to share a Google Sheet for editingLearn how to share a Google Sheet for editing using email invites or shareable links, and control who can edit, comment, or view your data.
How to shift cells down in Google SheetsRight-click a range and choose Insert cells > Shift down, or press Ctrl+Alt+= (Cmd+Option+= on Mac). Everything below moves down. See the interactive demo.
How to subtract in Google SheetsLearn how to subtract numbers, cells, and dates in Google Sheets using formulas, the MINUS function, and cell references.
Create interactive demos like this one — free, no coding required.
Start for free →