A Google Sheet spreadsheet is a simple and free way to store data in spreadsheet form. If the document contains a lot of information, learn how to quickly find the one you need: it will save you a lot of time!
Method 1 of 2: Search in a web browser
Step 1. Open the document in Google Drive
Step 2. Click on the tab you want to search
Step 3. Open Find and Replace
You can do this in two different ways.
- Under the title of the document, click on the tab Editing. From the drop-down menu that will appear, select Find and replace.
- You can also use the shortcut CTRL + H or CTRL + F on your keyboard. The “Find and Replace” window will appear.
Step 4. Type the word you are looking for in the Search field
Do not enter anything in the "replace" field, unless this is the action you want to take.
Step 5. Click OK
A search will be performed on the document and if it contains the word, its first occurrence will be highlighted (on the document, the word will be circled in blue).
You will be able to search for the following occurrences by clicking your Enter key again. If the word appears more than once, the blue box will skip the next time it appears. If the tool does not find anything, the search will return to the starting point and will be carried out in a loop
Step 6. Get out
When you are finished, click OK, at the bottom of the “Find and replace” window, to exit and return to the spreadsheet.
Method 2 of 2: Search using the Google Sheets app
Step 1. Launch Google Sheets
Locate the application icon on your device and click on it. The application icon represents a green document or folder.
You won't need to identify yourself unless this is your first time using the app
Step 2. Locate the correct document
All of your Google Spreadsheets, the ones you've created and those that have been shared with you, will be displayed. Scroll down and find the document you want to open.
Step 3. Open the spreadsheet
Click on the spreadsheet you need. The document will open on your screen.
Step 4. Access the search function
You can access this feature from the menu. Click on the three vertical dots in the upper right corner to pull down the menu. In it, click Find and replace and a search box will appear at the top of the spreadsheet.
Step 5. Do a research
Enter the word, number or sequence you want to search for in the field. To start the search, tap on the button representing a small magnifying glass on your keyboard.
Step 6. Review the results
If a result is found, the first cell that contains it will be highlighted and your cursor will be placed on it.
Just to the right of the search box, you will see two arrow buttons. The arrow pointing up will take you back to the previous result. The arrow pointing down will take you to the next result. To go to the next cell with the result, click the down arrow. Keep clicking on it until you find the data you are looking for
Step 7. Exit the search
When you're done, click the X in front of the search box to exit the search and return to the document.