To search in Google Sheets, press Ctrl+F on Windows or Command+F on Mac, enter a word or number, then use the arrows or Enter to move through matches. For more control—such as searching every sheet, matching exact cell contents, or looking inside formulas—open Edit > Find and replace. You need a Google Sheets file open in a web browser and permission to view it.
What You’ll Need
- A Google account and a spreadsheet open in Google Sheets in a web browser.
- Viewer or higher access to the file. You can search a file you can view; editing permission is needed to replace its contents.
- A word, number, phrase, or other text you expect to find. If you are unsure of the exact wording, start with a distinctive part of it.
Step-by-Step
- Open the spreadsheet. Go to Google Sheets and open the file you want to search. If you have several files with similar names, check the file title at the top before searching. If the sheet is view-only, you can still find content, but you cannot change it.
- Choose a search method. For a quick search, press Ctrl+F on Windows or ChromeOS, or Command+F on Mac. You can also use Edit > Find and replace for advanced options. The keyboard shortcut usually opens a compact find box; the menu opens a dialog with controls for search scope and matching.
- Enter the search term. Type the text or number into the find field. Search can be useful for a complete word, a partial word, a customer name, an order number, or a value such as 250. Start with a distinctive term: searching for “North” is more likely to narrow down a large sheet than searching for “the.”
- Move through the matches. In the quick find box, use its next and previous controls, or press Enter to move to the next match and Shift+Enter to go back when those shortcuts are available. In the Find and replace dialog, click Find to move to a match. Sheets selects the matching cell so you can inspect its row, column, and surrounding information. Check the whole row before acting; the same text may appear in several records.
- Search beyond the current sheet if needed. Open Edit > Find and replace. In the Search dropdown, choose This sheet to limit the search, All sheets to search the workbook’s tabs, or Specific range to restrict it to a range you specify. For example, if you choose Specific range, enter a range such as
Orders!A2:D500using the sheet name and cell references appropriate to your file. Confirm the range carefully; a search limited to one column will not find a match in another column. - Set how closely the text must match. In Find and replace, select Match case if uppercase and lowercase must be treated differently. Select Match entire cell contents if you want the entire cell to equal the search term, rather than finding that text inside a longer entry. For example, with Match entire cell contents selected, searching for
Westwill not match a cell containingWest Office. Leave these options off for a broader search. - Search formulas when that is what you need. A cell containing a formula usually displays its calculated result, not the formula text. If you need to find a function or reference such as
SUMorB2inside formulas, open Edit > Find and replace and select Also search within formulas. This is different from searching for a displayed value: a cell might show125while its formula contains the word or cell reference you are looking for. - Use regular expressions only for a pattern search. In Find and replace, select Search using regular expressions when you need to find text that follows a pattern rather than one literal phrase. For example,
^INV-searches for text beginning with “INV-”. Regular expressions give punctuation special meanings, so a period or asterisk may not act like an ordinary character. Turn the option off for a normal word search. - Finish the search and review the result. Close the find box or click Done when you have found what you need. If you used Find and replace, verify the selected cell and scope before making any changes. A search identifies matching content; it does not automatically tell you whether that record is current, correct, or the one you intended.
To replace text, use Edit > Find and replace, enter the old text in Find and the new text in Replace with, and click Replace to update one match at a time. Use Replace all only after checking the scope and match options. For example, replacing “Open” with “Closed” across All sheets could affect notes or labels as well as status cells. If you only want to locate information, do not click Replace all.
Common Mistakes
- Searching only the active sheet. A quick Ctrl+F or Command+F search may be scoped to the current sheet. If you expect a result on another tab, use Edit > Find and replace and set Search to All sheets.
- Using exact matching without realizing it. Match entire cell contents excludes cells that contain extra words, spaces, or punctuation. Turn it off when you are looking for a phrase inside longer text.
- Expecting a value search to reveal a formula. A displayed result and the formula that produced it are different things. Enable Also search within formulas if your target is formula text.
- Replacing too broadly. Replace all can change every match in the selected scope, including cells you did not mean to edit. Search first, check the range and options, and replace individual matches when the effect is uncertain.
- Searching a different version of the text. A trailing space, punctuation mark, different spelling, or changed identifier can prevent an exact match. Try a shorter distinctive fragment and review the cell contents.
Tips
- Use the smallest distinctive piece of text that identifies the item. A customer surname or part of an order ID is often more useful than a generic word.
- When results are numerous, narrow the scope to a specific sheet or range before searching. This reduces unrelated matches and makes it easier to confirm the right row.
- Search for one term at a time, then use the row and column headings to check context. A match in a comment-like note or a historical record may not be the current entry you need.
- If you will repeat a complex search, note the sheet, range, and matching options you used. That makes it easier to run the same search consistently later.
- Google Sheets search is not the same as searching for a file in Google Drive. If you do not know which spreadsheet contains the information, locate the file in Drive first, then search inside it.
- In Excel, the interface is different: Microsoft Excel for Windows has Find under Home > Find & Select > Find. The Google Sheets keyboard shortcuts and menu names in this guide apply to Sheets in a browser.
Troubleshooting
No results appear: Check that the search field contains the expected text and that you have selected the correct sheet or All sheets. Turn off Match entire cell contents and Match case, then try a shorter fragment. If you are looking for a formula rather than its displayed result, enable Also search within formulas. Also check for misspellings, punctuation, or spaces in the source cell.
The search finds the wrong match: Review the active scope and matching options. If the term is common, search for a longer phrase or identifier. Use Match entire cell contents when a short term is matching inside longer entries, or Match case if capitalization distinguishes the item you need. Inspect the selected cell’s row and column before assuming it is the right record.
Ctrl+F or Command+F does not open the Sheets find box: Click a cell in the spreadsheet and try again. Browser extensions or browser shortcuts can sometimes affect keyboard behavior. If the shortcut still does not work, use Edit > Find and replace from the Sheets menu. On a Mac, use Command rather than Ctrl for the quick search shortcut.
You can find text but cannot replace it: Confirm that you have editing permission. Viewers can search but cannot change the spreadsheet. If you are allowed to edit but a protected range blocks changes, ask the file owner or an editor with permission to update that range. Do not make a separate copy unless that is appropriate for your work.
The result seems to be missing from a filtered or hidden area: Confirm the selected search scope and inspect the relevant sheet and range directly. A filter can hide rows from view, and hidden rows or columns can make it harder to recognize where a match belongs. Clear or adjust the filter if you are authorized to do so, then check the surrounding row data. Avoid changing the sheet’s layout just to search if you are unsure how other people use it.
Frequently Asked Questions
How do I search all tabs in a Google spreadsheet?
Open Edit > Find and replace, then set Search to All sheets. Enter your term and click Find. The quick Ctrl+F or Command+F search is best for a fast lookup, but use the dialog when you need to choose the workbook-wide scope.
Can I search for part of a word or phrase?
Yes. Enter the fragment you want to locate and leave Match entire cell contents unchecked. Sheets can then find it within a longer cell entry. If the phrase is common, add more of the text to reduce unrelated matches.
Does Google Sheets search formulas or just displayed values?
To search inside formula text, select Also search within formulas in Edit > Find and replace. Otherwise, search results are generally based on the content shown in the cells. Remember that a calculated result can be different from the formula stored in that cell.
Can I search by color or formatting?
Find and replace is primarily for text and cell contents, not a general search for formatting or fill color. If color marks a category, search for the category label or another value in the same row. You can also use a filter or sort when the data includes a column that identifies the category.
Can I search a Google Sheet on my phone?
Yes. In the Google Sheets mobile app, open the spreadsheet, tap More (the three-dot menu), and choose Find and replace. Enter your search term and use the navigation controls to review matches. The exact controls can vary slightly by device and app version; the browser steps above apply to Sheets on a computer.
What is the difference between Find and Replace?
Find locates matching content so you can review it. Replace changes a match to different text, and Replace all changes every match in the selected scope. Use Find when you only need to locate information, and review the scope carefully before using either replacement option.
Related
- How to Paste in Excel Without Replacing Existing Data
- Paste Just Values in Excel: Keyboard Shortcuts and Steps
- How to Paste a Link in Excel as Plain Text, Not Hyperlink
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook Email Archive: How to Save Messages SafelyTo archive an email in Outlook, select the message and choose Archive on the toolbar or ribbon; Outlook…
- Subscript in Google Sheets: Methods That WorkTo show subscript in Google Sheets, paste subscript Unicode characters such as the ₂ in H₂O; Sheets does…
- Flip Rows and Columns in Excel: Easy Ways to TransposeThe easiest way to flip rows and columns in Excel is to copy the range, choose an empty…
- How to Change Pane View in OutlookTo change the pane view in Outlook, open View, choose Layout if your version shows it, then select…
- How to Divide in Excel Without Getting a Date ResultTo divide in Excel without seeing a date, enter a formula such as =A2/B2, then change the result…
- Excel Repair Tools for XLS and XLSX Files: What WorksFor an XLS or XLSX workbook that will not open, first make a copy of the file, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.