To search a Google spreadsheet, open it in Google Sheets in a web browser and press Ctrl+F on Windows or ⌘+F on Mac, then type the word or number you want to find. Use Edit > Find and replace when you need to search across tabs, narrow the search, or replace a match. Searching helps you locate text, numbers, dates, or formula content without scanning cells manually.
The steps below are for Google Sheets in a browser. You will need access to the spreadsheet and permission to view it; editing is required if you plan to replace data. Google Sheets saves changes automatically, but it is still sensible to confirm the selected cell and replacement before making a change.
What You’ll Need
- A web browser and access to the Google Sheets file.
- View permission to search; edit permission to replace or change cell contents.
- A word, number, date, or other value to look for. If possible, note which tab or range may contain it.
Step-by-Step
- Open the spreadsheet. Go to Google Sheets and open the file. If it is in Google Drive, double-click the file or select it and choose Open with > Google Sheets. Check the tabs along the bottom so you know whether you are looking at the right worksheet. A spreadsheet can contain several tabs, and a quick find may search only the currently selected tab.
- Start a basic search. Click a cell in the sheet, then press Ctrl+F on Windows or Chromebook, or ⌘+F on a Mac. You can also choose Edit > Find and replace from the menu. Type the search term in the small Find box. Search for a distinctive part of a value if you are unsure of its full spelling.
- Review the match and move through results. Google Sheets highlights a matching cell and shows a result count or navigation controls in the Find box, depending on the current interface. Use the next and previous arrows, or press Enter to move to another match. Check the cell address and surrounding row or column labels before assuming a result is the one you need.
- Search a whole tab or the entire file. For more control, open Edit > Find and replace. In the dialog, enter the value under Find, then use the Search setting to choose This sheet, All sheets, or a specific range when those options are available. Choose All sheets to look through multiple tabs; choose This sheet if you want to avoid matches elsewhere in the file.
- Limit the search when needed. In the Find and replace dialog, use options such as Match case or Match entire cell contents to make results more precise. Match case distinguishes uppercase and lowercase letters. Match entire cell contents finds a cell only when its contents are the same as the search text, rather than finding that text as part of a longer entry. Check Also search within formulas if you need to locate text used in a formula rather than just a displayed result.
- Search within a known range. If the relevant data is in a particular block, select or specify that range in Find and replace rather than searching the whole file. For example, you might search a customer-name column instead of notes, totals, and other unrelated areas. Make sure the range includes all the rows you care about; a narrow range can make a valid match appear to be missing.
- Replace one occurrence, if that is your goal. In Edit > Find and replace, enter the existing text in Find and the new text in Replace with. Use Find first to review a match, then choose Replace to change that occurrence and continue checking results. This is safer than replacing every occurrence when only one cell should change.
- Replace all only after checking the scope. If every matching occurrence should change, confirm the sheet or range, the exact search text, and the replacement text before choosing Replace all. Read the confirmation message and review several changed cells afterward. Replacing all may affect cells you did not expect, including matches on other tabs if All sheets is selected.
- Close the search and verify the result. Close the Find box or dialog when finished, then inspect the cell in context. If you replaced data, verify that the new value is correct and that formulas or labels nearby still make sense. Google Sheets saves edits automatically, but you can use Edit > Undo shortly after a mistaken replacement if you have not made other changes you need to keep.
Keyboard shortcuts can vary with browser and keyboard settings, so the menu path Edit > Find and replace is a reliable alternative. In Excel for Microsoft 365, Ctrl+F also opens Find on Windows and Command+F works on Mac, but the dialogs and search settings are not identical to Google Sheets. The instructions here use Google Sheets menus and controls.
Common Mistakes
- Searching the wrong tab. A basic search may not include every worksheet. If you expect a match on another tab, use Find and replace and set Search to All sheets.
- Including extra spaces or punctuation. A search for Acme Inc may not match Acme Inc. if the cell contains a period, or may behave differently if there are leading or trailing spaces. Try a shorter, distinctive portion of the text.
- Using Match entire cell contents unintentionally. This option will not find a search term embedded in a longer cell value. Turn it off when you want partial matches.
- Confusing displayed values with formulas. A cell may display a result such as a total while its formula contains different text. Enable Also search within formulas when you need to locate formula content.
- Choosing Replace all too quickly. A short term can appear in unrelated words or on other tabs. Review the scope and use Find to inspect matches before applying a bulk replacement.
Tips
- Search for a unique word, ID, or number rather than a common term such as the or 1. A distinctive search reduces irrelevant results.
- If the term may be written in different ways, try a key fragment first. For instance, searching for 415 can help locate a phone number even if the punctuation or spacing varies.
- Look at the row and column headings around a match. This confirms whether the result belongs to the right record, especially in a sheet with repeated names or codes.
- When you only need to find information and not edit it, avoid typing in a cell after searching. Click the result or use the navigation controls so you do not accidentally overwrite a value.
- For repeated checks, use a consistent method: choose the tab or range, set any matching options, then search. This makes it easier to compare results and notice when a search scope has changed.
- Search and filters solve different problems. Find locates matching cell content; a filter temporarily displays rows that meet conditions. If you need to review all records matching several criteria, consider using the sheet’s filter controls instead of repeatedly jumping between individual matches.
Troubleshooting
No matches appear: Check spelling, punctuation, spaces, and whether the search is case-sensitive. Confirm that Search is set to the correct tab or range, turn off Match entire cell contents to allow partial matches, and enable Also search within formulas if the text may be part of a formula. If the value is a date or number, try searching for the visible portion or a simpler part of it.
The match is on another tab: Open Edit > Find and replace and change Search from This sheet to All sheets. If you chose a specific range, widen it or remove that restriction. A search limited to a selected block will not find entries outside it.
Find works, but Replace does not: You may have view-only access, or the sheet or range may be protected. Ask the file owner for edit permission or for access to the protected area. Also check that the Find field contains the original text and Replace with contains the intended new text.
Replace all changed too much: Use Edit > Undo as soon as possible, then reopen Find and replace and narrow the scope or search phrase. If subsequent edits make Undo unsuitable, check the file’s version history under File > Version history > See version history. Restore an earlier version only after considering that it can also roll back other people’s changes.
The search box or shortcut behaves unexpectedly: Click inside the spreadsheet first, then try Edit > Find and replace from the Sheets menu. Browser shortcuts can sometimes be intercepted by the browser or an extension. If the sheet is open in a mobile app, the layout and controls differ; use the app’s menu search option or open the file in a desktop browser for the full dialog.
Frequently Asked Questions
Can I search every tab in a Google Sheets file?
Yes. Open Edit > Find and replace and choose All sheets in the Search setting. A basic Ctrl+F or ⌘+F search may be limited to the current sheet, so use the dialog when you need a workbook-wide search.
Can I search for part of a cell’s text?
Yes. Enter the fragment you want to find and make sure Match entire cell contents is not selected. For example, searching for north can find a cell containing North region when case matching is not enabled.
Can I search for text inside a formula?
Yes. In Find and replace, enable Also search within formulas. Without that setting, the search may focus on cell values rather than the formula text that produces them.
How do I find and replace without changing every match?
Use Edit > Find and replace, enter both terms, and choose Find before Replace. This lets you inspect a match and replace individual occurrences. Avoid Replace all unless every match in the selected scope should change.
Does searching change the spreadsheet?
No. Finding a value only navigates to matching cells. Replacing text or editing a cell does change the file, and those actions require edit access. Check the result after making a replacement.
Can I search a Google Sheet in Excel?
You can search a downloaded or opened spreadsheet in Excel, but its controls differ. In Excel for Microsoft 365, use Home > Find & Select > Find on Windows; on Mac, use Edit > Find or Command+F. To search Google Sheets as described here, open the original file in Sheets in a browser.
Related
- How to Paste in Excel and Keep Formatting
- How to Paste in Excel Only Visible Cells Without Hidden Rows
- Paste in a Filtered List in Excel Without Hidden Rows
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Autofit a Picture in an Excel CellTo make a picture resize with an Excel cell, select it and choose Picture Format > Place in…
- Excel Hide Column Numbers? Hide Row and Column HeadingsTo hide Excel’s column letters and row numbers, open the View tab and clear Headings in the Show…
- Customizable Invoice Template in Excel: How to Make OneYes. You can make a customizable invoice template in Microsoft Excel by laying out your business and customer…
- Record Inventory in Excel: A Practical Spreadsheet GuideTo record inventory in an Excel spreadsheet, give every item a unique SKU, record stock movements, and calculate…
- How to Keep Spaces Between Text When Concatenating in ExcelTo keep a space between two pieces of text in Excel, include a space character as part of…
- Combine Two Columns in Google Sheets: Formulas and MoreTo combine the contents of two columns into one, enter a formula such as =A2&" "&B2 in an…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.