Google Docs workbooks are free and easy to use. You can use the workbook to organize data in a tabular format. If you have a lot of information in a table, knowing how to search for specific keywords or topics will make your job a lot easier.
Step
Method 1 of 2: Via Browser
Step 1. Open the workbook you want from Google Drive
Step 2. Open the tab containing the data you want to search
Step 3. Open the "Find and Replace" option by following one of the following methods:
- Drop-down menu: Click the Edit tab in the drop-down menu, then scroll through the menu to find the Find and Replace option.
- You can also use the keyboard shortcut Ctrl+H or Ctrl+F to open the Find and Replace window.
Step 4. Enter the keyword you want to search for in the Find box
Do not fill in the Replace box, unless you want to replace the data.
Step 5. Click Find
The computer will perform a data search. If the computer finds the keyword you entered in the workbook, the first entry it finds appears. The entry will be marked with a blue box in the workbook.
You can click Find again to scroll through the search results. The computer will display the next search results (if any). If the computer finds no other search results, you will see the message "No more results, looping around"
Step 6. When you're done searching, click "Done" in the lower right corner of the "Find and Replace" window to close it
Once the window closes, you will be taken back to the workbook.
Method 2 of 2: Via Google Sheets App
Step 1. Tap the green document or file icon on your phone to open the Google Sheets app
You don't need to sign in to Google Sheets, unless it's your first time using the app
Step 2. Find the workbook you want to open
All workbooks that you have access to, both your own and those shared with you, will appear on the app screen. Swipe to find the workbook you're referring to.
Step 3. Tap a workbook to open it
The workbook will appear on the screen.
Step 4. Access the search feature via the menu
Tap the three vertical dots icon in the upper right corner of the screen to open the menu, then tap "Find and Replace". A search box will appear at the top of the workbook.
Step 5. Perform a search by entering keywords in the search box
When you're done, tap the "Search" button on your keyboard to start the search.
Step 6. Look at the search results
If the keyword you entered is found in the workbook, it will be tagged, and you will be taken to the keyword's location.
You will see two directional buttons to the right of the search bar. To display the previous search results, tap the up button, and to display the subsequent search results, tap the down button. Keep tapping the button until you find the data you want
Step 7. Once you are done with the search, tap on the “X” button in the search bar to close it
Once the search bar closes, you will be taken back to the workbook.