# How To Search in Google Sheets | Capterra > Want to streamline your data analysis and retrieval? Learn how to search in Google Sheets to quickly identify, reference, and modify spreadsheet data. Source: https://www.capterra.com/resources/how-to-search-in-google-sheets --- IT & Software Development # How To Search in Google Sheets: A Comprehensive Guide By MJ Barber MJ Barber MJ Barber is a writer specializing in digital marketing and content strategy. They are a frequent contributor to trusted businesses resources including Capte... [See bio & all articles](https://www.capterra.com/resources/author/mj-barber-guest-contributor/) Published September 14, 2023 5 min read Table of Contents - [Using the 'Find' function](#how-to-search-google-sheets-using-the-find-function) - [Using 'Find and Replace'](#how-to-search-in-google-sheets-using-find-and-replace) - [Using the 'Match' function](#how-to-search-in-google-sheets-using-the-match-function) - [Using Conditional Formatting](#how-to-search-in-google-sheets-using-conditional-formatting) ## Learn how to search in Google Sheets to simplify text manipulation, data analysis and management in just a few steps. Good business decisions are made when business leaders and decision makers can access and share important data with their team members, investors and clients. Many small-and-midsize-businesses (SMBs) use [Google Sheets](https://www.capterra.com/p/169718/Google-Sheets/) to store, organize, present and share data.  Mastering the ins and outs of Google Sheets can help you collaborate and chat with geographically distant team members. The web-based application offers various features, such as add and delete rows and columns, search and replace data.  This comprehensive guide explores how to use different built-in functions to search in Google Sheets, so you can easily find the words or phrases you’re looking for. We’ll explore the workings of each function and learn their benefits. ## How to search Google Sheets using the ‘Find’ function The ‘Find’ function in Google Sheets is the easiest method of locating data in Google Sheets. You can use this feature to find the position where the text string is first detected. The Find function can simplify many data-related tasks, such as data analysis, text manipulation and help you quickly retrieve information for shareholder or client meetings. _Use Ctrl + F to open the Find function. Screenshot provided by the author_ **Use the Find function to search Google Sheets by following these steps:** Step 1: Use the keyboard shortcut Ctrl + F keys in Windows or Command + F keys in macOS. This will open a Find window with a field to enter text.  Step 2: Type the text or number you are searching for, and it will show you how many times the text string exists in the spreadsheet.  Step 3: Use the up and down arrow buttons to navigate.  Step 4: You’ll see the cells with your text string highlighted in green, and you can scroll through them to find what you’re looking for. ## How to search in Google Sheets using ‘Find and Replace’ The Find feature is straightforward to use but also the most basic feature to look for specific data. If you want to hone down your search parameters, you can use Google Sheets’ ‘Find and Replace’ function. You can filter your search by match case, using regular expressions, or extend your search to multiple sheets. _Press Ctrl + H to open the Find and Replace menu. Screenshot provided by the author._ **To search for data using Find and Replace in Google Sheets, follow these steps:** Step 1: Click on the Edit menu on the menu bar.  Step 2: Select the Find and Replace option from the dropdown menu. This opens a dialog box.  Step 3: You can open this box by pressing Ctrl + H keys in Windows or Command + H keys on macOS.  Step 4: Enter your text string into the Find box. The search will reveal all occurrences of your search term.  Step 5: You can conveniently replace all instances of that word or text string by entering new text into the Replace field and hitting the Replace button. ## How to search in Google Sheets using the ‘Match’ function The ‘Match’ function in Google Sheets is helpful when you need to know the relative position of an item within a specific range. **To get started searching in Google Sheets using the Match function, follow these steps:** Step 1: Type “=Match” in any cell or go to the Insert Menu and select “Function,” then “Lookup,” and then “Match.” _Select "Function", then "Lookup", then "Match". Screenshot provided by the author._ Step 2: Manually enter the search key or select a cell or block of cells.  - The search\_key is the value you are searching for. The range is where you would like the function to search for the text. And the search\_type uses a value to represent how the entries are stored in the selected range cells. 1: ascending order, 0: not ordered - only exact match, -1: descending order. **Example:** If you are searching for the term “Boston,” your cell entry would read “=match(“Boston,” \[insert cell range\],\[insert order value code\]” or “=match(“Boston,” A1:N45,0\]” ## How to search in Google Sheets using Conditional Formatting What if you want to learn how to search in Google Sheets and highlight all cells containing your specified search term instead of going through the results one by one? You can search Google Sheets using the ‘Conditional Formatting’ feature for this task.  **Let’s say you are searching for all cells containing “Boston.” Use the following steps:** Step 1: Start by navigating to the Format menu option from the menu bar. Step 2: Select the Conditional Formatting option to open the Conditional Format Rules sidebar.  Step 3: In the blank field titled “Apply to range,” you can limit your search to a certain range or simply select data range. If you select a specific range of cells, it will open a dialog box where you can choose the range and click OK.  Step 4: In the Format Rules dropdown menu, click on the dropdown arrow to select specific search criteria, such as “Is empty” or “Text contains”/”Text does not contain.” _In the Format Rules dropdown menu, click on the dropdown arrow to select specific search criteria. Screenshot provided by the author._ Step 5: Below that, you will see an input box labeled "Value or Formula," where you can type your search term. If you are looking for cells containing the word “Boston,” type in the word “Boston.”  Step 6: Under Formatting style, you can select Fill Color and choose the color you want to highlight the matching cells or rows.  Step 7: Click Done, and all cells matching your search criteria will be highlighted in the color of your choice. Further resources for Google Sheets management Now that you've learned how to search in Google Sheets, you can take your [data management](https://www.capterra.com/data-management-software/) skills to the next level. If you are interested in data-driven, actionable insights that can help you prepare, establish and engage your key stakeholders, check out the following from Capterra: - [Top Google Sheets alternatives](https://www.capterra.com/p/169718/Google-Sheets/alternatives/) - [Find the best spreadsheet software](https://www.capterra.com/spreadsheet-software/) ## Capterra's 2026 Software Buying Trends Report ### Download our 2026 Software Buying Trends Report to see how successful software adopters avoid disappointment and how your business can, too. * * * ### Was this article helpful? * * * ## About the Author [### MJ Barber](https://www.capterra.com/resources/author/mj-barber-guest-contributor/) MJ Barber is a writer specializing in digital marketing and content strategy. They are a frequent contributor to trusted businesses resources including Capterra. ### RELATED READING - [Bookkeeper vs. Accounts Payable Software: Which One Should You Choose?](https://www.capterra.com/resources/category-compare-bookkeeper-vs-accounts-payable-software/) - [How to Unlock Real AI Benefits in Sales and Marketing](https://www.capterra.com/resources/ai-benefits-sales-marketing-software/) - [5 Key Help Desk Software Features With Top Products That Offer Them](https://www.capterra.com/resources/help-desk-software-key-features/) - [How To Build the Right Project Management Tech Stack for Your Business](https://www.capterra.com/resources/project-management-tech-stack/) - [Why You Need Project Management Software With ADP Integration](https://www.capterra.com/resources/project-management-software-with-adp-integration/) - [Help Desk Software for IT Support: Features and Benefits 1,300+ Users Value](https://www.capterra.com/resources/it-help-desk-software-features-benefits/) - [AI in Talent Management Software: The Bridge Between Recruiting and Retention](https://www.capterra.com/resources/ai-talent-management-software/) - [Switching Accounting Software: Common Risks to Avoid in 2026](https://www.capterra.com/resources/switching-accounting-software-problems-risks/) - [Why Projects Fail, and What Actually Helps Teams Fix Them](https://www.capterra.com/resources/4-steps-to-completely-recover-from-project-failure/)