Search Within a Google Docs Spreadsheet

A Google Docs spreadsheet is a free and simple way to keep data in a spreadsheet form. If you add a lot of information, knowing how to quickly search for a keyword or topic is handy.

Steps

Browser

  1. Open the Google Docs spreadsheet in Drive.
  2. Open the tab that is relevant for your search.
  3. Open "Find and Replace". There are two ways to do this:
    • Drop-down menu: Click on the Edit tab in the drop-down menu. Scroll down to Find and Replace.
        • You can also do the short key by pressing CTRL+H or CTRL+F on your keyboard. The “Find and Replace” window will appear.
  4. Type the term or word you're searching for into the Find box. Don't put anything in the Replace box unless that's the action you're wanting to perform.
  5. Click Find. The document is searched and if the term or word is there, the first occurrence of it will appear (it will have a blue box around it in the spreadsheet).
    • You can continue scrolling for more by clicking on Find again. It will jump to the next occurrence if there is one. If it finds nothing, it will tell you "No more results, looping around".
  6. Exit. When you’re done, click “Done” at the bottom of the window to exit the “Find and Replace” window and go back to your spreadsheet.

Google Sheets App

  1. Launch Google Sheets. Locate the app on your device and tap on it. The app icon has a green document or file icon on it.
    • You won’t need to sign in, unless this is your first time to use the app.
  2. View your Google spreadsheets. All your Google spreadsheets, those you own and those shared with you, will be displayed. Swipe through the list and find the spreadsheet you’d like to open.
  3. Open a spreadsheet. Tap the spreadsheet you want to view. It will be opened on your screen.
  4. Access the search function. Search can be accessed from the menu. Tap the button with three vertical dots on the top right corner to bring out the menu. Tap “Find and Replace” from here, and a header search box will appear at the top of your spreadsheet.
  5. Do a search. Enter the word, number, or string you want to look for in the search box. Tap the Search key on your keypad to begin.
  6. View matches. If a match is found, the first cell containing the match will be highlighted and you will be brought to it.
    • On the rightmost part of the header search box are two arrow buttons. The upward button goes to the previous match and the downward button goes to the next match. Tap the downward button to go to the next cell containing the match. Continue tapping this button to go through the matches until you find the data you’re looking for.
  7. Exit. When you’re done, tap the “X” button in front of the header search box to exit the search function and go back to your spreadsheet.



Tips

  • You can use Replace if there is a spelling error, mis-phrased term, etc.

Things You'll Need

  • Google Docs spreadsheet, found in your Google Drive

Related Articles

Retrieved from "https://kipkis.com/index.php?title=Search_Within_a_Google_Docs_Spreadsheet&oldid=362459"