How to Search a Google Sheet

How to Search a Google Sheet
How to Search a Google Sheet
Anonim

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!

Steps

Method 1 of 2: Search in a web browser

Search Within a Google Docs Spreadsheet Step 1

Step 1. Open the document in Google Drive

Search Within a Google Docs Spreadsheet Step 2

Step 2. Click on the tab you want to search

Search Within a Google Docs Spreadsheet Step 3

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

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.

Search Within a Google Docs Spreadsheet Step 5

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

Search Within a Google Docs Spreadsheet Step 6

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

Search Within a Google Docs Spreadsheet Step 7

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

Search Within a Google Docs Spreadsheet Step 8

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.

Search Within a Google Docs Spreadsheet Step 9

Step 3. Open the spreadsheet

Click on the spreadsheet you need. The document will open on your screen.

Search Within a Google Docs Spreadsheet Step 10

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.

Search Within a Google Docs Spreadsheet Step 11

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.

Search Within a Google Docs Spreadsheet Step 12

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

Search Within a Google Docs Spreadsheet Step 13

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.

Popular by topic