In this tutorial, you will learn How to Search in Google Sheets
How to search in Google Sheets(Key takeaways)
The easiest way to search in Google Sheets is using the Keyboard Shortcut Ctrl+F on Windows and CMD+F on Mac OS which will open a Find box using which you can search your text.
Alternatively, you can also use the Find and Replace feature by clicking on the Edit->Find and Replace option. Simply provide the text in the Find area, Select the Match case option then Click on the Find button
How to Search in Google Sheets: Step by Step Guide
Enclosed are the steps to Search in Google Sheets :
Method 1: Search using Find and Replace feature
You can search a specific text and string using the Find and replace feature in Google Sheets
Following are the steps to search a specific text using Find and Replace
Step 1: Open Google Spreadsheet
Open your Google spreadsheet with your dataset where you want to search a text.
For example, we will use the below dataset
Step 2: Go to the Edit menu and Click on Find and Replace
Edit ->Find and Replace
You can also use the Keyboard Shortcut Ctrl+H key on your Keyboard on Windows PC and CMD+H on an Apple Mac OS
Step 3: Type the text in the Find area
- Once you click on Find and Replace option you will be presented with Find and Replace Window.
- On the Find and Replace screen type the text that you want to find in the Find area as shown below.
- Now Check the Match case option and Click on the Find button
It will find and return the result by Highlighting it in Blue color as shown below
Step 4: Find multiple occurrences of Text
Click on the Find button again if the text occurs multiple times in your spreadsheet
For example, we have added one more entry for the same text “Chelsea” and when we click on the Find button again it returns the result as shown below.
Once it reaches the last occurrence of the text it will return a message “No more Search results found, looping around“
Step 5: Click on the Close Done button to Close Find and Replace
Once you are done with your search you can click on the Done button in green to Close the Find and Replace Screen.
Method 2: Search using the Find Option
Following are the steps to Search using the Find option :
Step 1: Open Google Spreadsheet
Step 2 : Now press the keyboard shortcut Control + F on windows and Cmd + F on Mac OS.
Step 3: Type the text in the Find box
Once you press the keyboard Shortcut a Find box will appear on the Top right corner of your spreadsheet.
Type the Text which you want to find in your spreadsheet.
Once you type the text in the find box it will be returned in green color as shown above
Method 3: Using Conditional formatting
You can also use conditional formatting to Find a specific text on your Google Sheet.
Enclose are the steps to search in Google Sheets using conditional formatting
Step1: Select your entire dataset
Select your entire dataset where you need to find the text or string using conditional formatting
You can simply click on a cell with data and press the Ctrl+A key which will select the entire dataset
Step 2: Now click on the Format menu and Select Conditional formatting
Format->Conditional formatting
Step 3: Adjust the Format Rules
One the Conditional format rules Window, Go to the Format rules section and Click on the down arrow under the “format cells if” option
From the drop-down Select “Text contains“
Now type the text which you want to search in the value or formula area
Step 4: Now Click on the “Done” button.
- Your result will be highlighted in the default green color.
- You can also change the color in which your result is highlighted by changing the default color under Formatting style
How to Search in Google Sheets(Conclusion)
In the above tutorial, we have shown you various methods to quickly and easily search a text or string in Google Sheets. Feel free to use any of the above-shown methods whichever you find easy.
We hope this step-by-step tutorial on How to search in Google Sheets was helpful.
Related articles :
How to Insert Spin Button in Google Sheets ( Easy Guide )
How to Freeze Rows in Google Sheets
How to Calculate Square Root and Cube Root in Google Sheets(Quick & Easy Guide)
How to use SUMSQ Function in Google Sheets(Quick & Easy Guide )
