Recommended: Fix Windows Errors and Clear Junk Files in Minutes - Free Scan →Recommended: Update Every Outdated Driver on Your PC in One Scan - Free →
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
This Itechguide teaches you how to search in Google Sheets. The guide covers steps to search in Google Sheets from a PC, the Android and the iPhone Apps.
Option 1: Search in Google Sheets from a PC
- Open Sheets.Google.com from your PC. Then, if you have not signed in, sign in with your Google Account.
- From Google Sheets home page, open the spreadsheet you want to search.
You can open a saved Google spreadsheet from your recently opened spreadsheets. Alternatively, you could open your spreadsheet from Google Drive.
- When the spreadsheet opens, click Edit. Then, from the list of displayed options, click Find and Replace.
On a Windows PC, you could also open Find and Replace by pressing Ctrl and H keys simultaneously on your keyboard.
- When the Find and Replace pop up window opens, type what you want to search in the Find search box. Then, beneath the window, click Find.
You can modify your search to match case or Match entire cell contents. Google Sheets also offers options to perform RegEx or formula search.
- If what you searched exists in the spreadsheet, Google Sheets will highlight it in blue.
If clicking Find does not return a result, try pressing the Enter key on your keyboard.
Option 2: Search in Google Sheets Android App
- Open the Google Sheets App on your Android phone. If it is the first time you are opening the App, you will be required to login with your Google Account.
- When the App opens, open the spreadsheet you want to work on. Then, tap the 3 dots on the top right of the spreadsheet. A list of options will be displayed.
- From the displayed options, tap Find and Replace.
- Finally, type the word(s) or phrase you want to search in Google Sheets. If what you typed exists in the spreadsheet, it will be highlighted in blue.
In the rare instance that what you searched for is not highlighted, tap the search icon on your keyboard.
Option 3: Search in Google Sheets iPhone App
- Open Google Sheets App on your iPhone. Then, if it is the first time you are opening the App, sign in with your Google Account.
- When the App opens, open the Google spreadsheet you want to work on. Then, tap the 3 dots on the top right of the spreadsheet. Tapping the 3 dots displays a list of options.
- From the displayed options, tap Find and Replace.
- When Find and Replace opens, type the word(s) or phrase you want to find. Then, either tap on of the arrows beside the search box or tap Search on your keyboard.
When you tap the arrows or Search key, Google Sheets iPhone App will display how many times the word(s) or phrase was found in the spreadsheet. The result will be highlighted in blue. To see more results, tap one of the arrows.
If you found it helpful, click on “Yes” beside the “Was this page helpful” question below.
You may also express your thoughts and opinions by using the “Leave a Comment” form at the bottom of this page.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Clear out junk files and repair common Windows errors3Fix the driver behind crashes, sound loss and screen glitchesSpecial offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Finally, for more Google Itechguides, visit our Google How To page.
Quick Recap
Bestseller No. 1
Bestseller No. 3
Bestseller No. 5
Also popular on Amazon
Also popular on Amazon
Also popular on Amazon
Google Sheets Reference and Cheat Sheet: The unofficial cheat sheet reference for Google's free online spreadsheet application
- hole punched
- high quality card stock
- 4 pages
- made in USA
- keyboard shortcuts
Also popular on Amazon
Popular on Amazon
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.
