How to Search Within a Google Docs Spreadsheet

PDF download Download Article
Learn how to use Find and Replace in Google Sheets on your computer, Android, iPhone, or iPad
PDF download Download Article

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.

Things You Should Know

  • If you're using a computer, click the "Edit" menu and select "Find and replace."
  • On an phone or tablet, tap the three dots at the top of the sheet and select "Find and replace."
  • Use the arrows to navigate through the search results.
Method 1
Method 1 of 2:

On a Computer

PDF download Download Article
  2. Advertisement
  3. 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. Don't put anything in the Replace box unless that's the action you're wanting to perform.
  5. 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. 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.
    7. Advertisement
Method 2
Method 2 of 2:

Mobile App

PDF download Download Article
  1. 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. 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. Tap the spreadsheet you want to view. It will be opened on your screen.
  4. 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. 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. 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. 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.
    8. Advertisement


Community Q&A

Search
Add New Question
  • Question
    How can I scroll and search or find things in my sheets?
    Community Answer
    Use the Ctrl+F function. This lets you search any combination of words in your document.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 18
  • Question
    How do I search for all examples of a category? In the example above, how would I find all instances where the word "banana" appears?
    Community Answer
    You can do Ctrl+F, which will open a Find and Replace window.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 7 Helpful 4
  • Question
    Is there a way to scroll quickly through a large Google document?
    Community Answer
    If you are using a computer, roll your mouse over the bottom of the scroll bar. Once you are there, left-click, and you should be able to scroll quickly to the end of the document.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 4 Helpful 1
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Things You'll Need

      • Google Docs spreadsheet, found in your Google Drive

      You Might Also Like

      How to
      Use Google Drive: Step by Step Guide for Beginners
      How to
      Upload and Share a Spreadsheet on Google Docs
      How to
      Create a Graph in Google Sheets
      How to
      Alphabetize in Google Docs: 4 Simple Methods
      How to
      Download Images from a Google Doc
      4 Easy Ways to Download and Save Google Docs
      How to
      Use Google Sheets: The Ultimate Guide for Getting Started
      How to
      Make a Brochure Using Google Docs: Quick Guide
      How to
      Convert a Google Doc to a PDF on iPhone or iPad
      Inserting Videos to Google Docs with Google Slides
      How to
      Make a Card in Google Docs
      4 Easy Ways to Add Captions to Images in Google Docs
      9 Easy Steps to Flip an Image in Google Docs
      How to
      See a Google Doc's Version History
      Advertisement

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 265,958 times.

      Is this article up to date?

      Advertisement