How to Do a Google Drive Worksheet Search: 13 Steps

Table of contents:

How to Do a Google Drive Worksheet Search: 13 Steps
How to Do a Google Drive Worksheet Search: 13 Steps

Video: How to Do a Google Drive Worksheet Search: 13 Steps

Video: How to Do a Google Drive Worksheet Search: 13 Steps
Video: How to use Google Drive - Tutorial for Beginners 2024, November
Anonim

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

Search Within a Google Docs Spreadsheet Step 1
Search Within a Google Docs Spreadsheet Step 1

Step 1. Open the workbook you want from Google Drive

Search Within a Google Docs Spreadsheet Step 2
Search Within a Google Docs Spreadsheet Step 2

Step 2. Open the tab containing the data you want to search

Search Within a Google Docs Spreadsheet Step 3
Search Within a Google Docs Spreadsheet Step 3

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.
Search Within a Google Docs Spreadsheet Step 4
Search Within a Google Docs Spreadsheet Step 4

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.

Search Within a Google Docs Spreadsheet Step 5
Search Within a Google Docs Spreadsheet Step 5

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"

Search Within a Google Docs Spreadsheet Step 6
Search Within a Google Docs Spreadsheet Step 6

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

Search Within a Google Docs Spreadsheet Step 7
Search Within a Google Docs Spreadsheet Step 7

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

Search Within a Google Docs Spreadsheet Step 8
Search Within a Google Docs Spreadsheet Step 8

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.

Search Within a Google Docs Spreadsheet Step 9
Search Within a Google Docs Spreadsheet Step 9

Step 3. Tap a workbook to open it

The workbook will appear on the screen.

Search Within a Google Docs Spreadsheet Step 10
Search Within a Google Docs Spreadsheet Step 10

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.

Search Within a Google Docs Spreadsheet Step 11
Search Within a Google Docs Spreadsheet Step 11

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.

Search Within a Google Docs Spreadsheet Step 12
Search Within a Google Docs Spreadsheet Step 12

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

Search Within a Google Docs Spreadsheet Step 13
Search Within a Google Docs Spreadsheet Step 13

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.

Recommended: