1
Navigate to Google Sheets and open or create the spreadsheet to search.
Open the Google Sheets document to begin searching for specific text within the spreadsheet.
How to search for words in Google Sheets
Learn how to search for and locate specific elements within a Google Sheets spreadsheet. This guide walks you through opening the document, using the find shortcut, and interacting with the search input fields to quickly find the data you need.
Operations
2
Press Cmd + F
Press Cmd + F
3
Click the More options button
Click the More options button in the find bar at the top right of the screen to access advanced search settings.
4
Click the Find text box
Click the text input field next to "Find" in the Find and replace dialog to enter your search term.
5
Click additional options for the search.
Click additional options for the search.
6
Click the Find button
Click the Find button at the bottom of the Find and replace dialog to locate the entered text.
7
The first cell with the word will be selected.
The first cell with the word will be selected.
8
Click "Find" to continue searching for additional occurrences.
Click "Find" to continue searching for additional occurrences.
9
When all results are found, click "Done"
When all results are found, click "Done"
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.