How To Search Within A Google Docs Spreadsheet: 13 Steps

Skip to ContentQuizzes

• PRO Courses Hot Guides Tech Help Pro Expert Videos About wikiHow Pro Upgrade
• QUIZZES All Quizzes Hot Love Quizzes Personality Quizzes Trivia Quizzes Taylor Swift Quizzes
• EDIT Edit this Article
• EXPLORE Tech Help ProAbout UsRandom ArticleQuizzes Request a New ArticleCommunity DashboardTrendingForums Arts and EntertainmentArtworkBooksMoviesComputers and ElectronicsComputersPhone SkillsTechnology HacksHealthMen's HealthMental HealthWomen's HealthRelationshipsDatingLoveRelationship Issues Hobbies and CraftsCraftsDrawingGamesEducation & CommunicationCommunication SkillsPersonal DevelopmentStudyingPersonal Care and StyleFashionHair CarePersonal Hygiene Quizzes Love Quizzes Personality Quizzes Fun Games ForumsArts and EntertainmentFinance and BusinessHome and Garden Relationship QuizzesCars & Other VehiclesFood and EntertainingPersonal Care and Style Sports and FitnessComputers and ElectronicsHealthPets and Animals TravelEducation & CommunicationHobbies and CraftsPhilosophy and Religion Work WorldFamily LifeHolidays and TraditionsRelationships Youth
• LOG IN

  Log in

  Social login does not work in incognito and private browsers. Please log in with your username or email to continue. Facebook Google wikiHow Account No account yet? Create an account
• RANDOM

• Home
• Random
• Browse Articles
• TrendingNew
• Quizzes & Games
• All QuizzesHot
• Love Quizzes
• Personality Quizzes
• Fun Games
• Dating Simulator
• Learn Something New
• Forums
• Courses
• Happiness Hub
• Explore More
• Support wikiHow
• About wikiHow

• Log in / Sign up

Terms of Use wikiHow is where trusted research and expert knowledge come together. Learn why people trust wikiHow

• Categories
• Computers and Electronics
• Internet
• Website Application Instructions
• Google Applications
• Google Docs

How to Search Within a Google Docs Spreadsheet Download Article Learn how to use Find and Replace in Google Sheets on your computer, Android, iPhone, or iPad Author Info

Last Updated: October 25, 2022 Tested

Download Article

• On a Computer
|
• Mobile App
|
• Video
|
• Q&A
|
• Tips
|
• Things You'll Need

|Show more |Show less X

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 11 people, some anonymous, worked to edit and improve it over time. The wikiHow Tech Team also followed the article's instructions and verified that they work. This article has been viewed 267,063 times. Learn more...

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.

Steps

Method 1 Method 1 of 2:

On a Computer

Download Article

1. 1 Open the Google Docs spreadsheet in Drive.
2. 2 Open the tab that is relevant for your search. Advertisement
3. 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. 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. 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. 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.
Advertisement

Method 2 Method 2 of 2:

Mobile App

Download Article

1. 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. 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. 3 Open a spreadsheet. Tap the spreadsheet you want to view. It will be opened on your screen.
4. 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. 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. 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. 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.
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

• You can use Replace if there is a spelling error, mis-phrased term, etc. Thanks Helpful 1 Not Helpful 0

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 toFind and Replace on Excel on iPhone or iPad How toReplace Values in Excel 5 Easy Steps to Find Words or Numbers in Microsoft Excel How toUse "Find" and "Find and Replace" Features in Microsoft Word Documents How to Search a Website for a Word: 3 Easy Methods How toEdit Google Sheets on Mobile How to Search for a Word or Phrase in a PDF Document How to Use Google Sheets: The Ultimate Guide for Getting Started How toEdit a Google Doc How toDelete Duplicates in Word How to Alphabetize in Google Docs: 4 Simple Methods Sorting Data in Google Sheets: Android Mobile Guide 3 Simple Ways to Highlight a Column in Google Sheets How to Make a Google Spreadsheet: Beginners Guide Advertisement

About This Article

Tested by: wikiHow Technology Team wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, 11 people, some anonymous, worked to edit and improve it over time. This article has been viewed 267,063 times. How helpful is this? Co-authors: 11 Updated: October 25, 2022 Views: 267,063 Categories: Google Docs In other languages Spanish Russian Indonesian German Italian Dutch French Arabic

• Print
• Send fan mail to authors

Thanks to all authors for creating a page that has been read 267,063 times.

Is this article up to date?

Yes No Advertisement Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Tested by: wikiHow Technology Team Click a star to vote Co-authors: 11 Updated: October 25, 2022 Views: 267,063

Quizzes & Games

Random Name GeneratorGenerate NamesBaby Name GeneratorGenerate NamesIQ TestTake QuizLeetspeak TranslatorGenerateAm I Smart QuizTake QuizWhat Age Is My Brain QuizTake Quiz

You Might Also Like

How toFind and Replace on Excel on iPhone or iPadHow toReplace Values in Excel5 Easy Steps to Find Words or Numbers in Microsoft Excel How toUse "Find" and "Find and Replace" Features in Microsoft Word Documents

Featured Articles

What Does It Mean If Someone Tries to Kill You in Your Dream?200+ Best Questions to Ask Someone You Like (Texting & IRL)How Beautiful Am I Quiz13 Types of Hairlines for Men and Women (And How to Maintain Yours)Which of the 8 Face Shapes Do You Have? Helpful Tips & Style GuidanceMental Illness Test

Trending Articles

Let Us Rate You 1-10: Attractiveness Scale QuizAm I a Gigachad or Totally Chopped?How Rare Is My Birthday QuizHow Nonchalant Am I QuizCan We Guess If You're Single or Taken?How toMake Out

Featured Articles

How toEnjoy the HolidaysHow to Get 250 Grams of Protein Daily: Best Foods, Meal Plans & MoreAm I Girly Quiz200 Fun, Flirty, & Deep Questions to Get to Know a Guy BetterHow to Tighten Skin Under Your Chin: Natural or Surgical OptionsWhat Would My Nickname Be Quiz

Featured Articles

21 Common Hand Signs & Gestures (& What They Mean)170+ Best Useless Facts That Sound Like LiesIs He Interested In Me Quiz15 Signs Your Ex Misses You (and What to Do About It)How to Observe Hanukkah (From Candle Lighting to Latke Frying)165+ "You Are Special" Quotes For Friends, Family, Partners & More

Watch Articles

How toWrap a Round GiftHow toSteam in an OvenHow to Make Plant-Based Meat: 4 Incredible RecipesHow toClean a Silver Necklace4 Easy Ways to Open a Can of SodaHow toPart Your Hair

Trending Articles

Have I Met My Soulmate Yet Quiz180 Good Comebacks & Savage Roasts to Win Any ArgumentAm I a Furry QuizWhat Are the Gay Male Body Types (And Which Do You Have?)What Should My Name Really Be QuizRandom Fortune Generator

Quizzes & Games

Music Notes & Symbols TestTake QuizHow Many Brain Cells Do I Have QuizTake QuizMemory TestTake QuizUsername GeneratorGenerate NamesHow Well Do I Know Gen Z Slang QuizTake QuizCursed Text GeneratorGenerate

• Categories
• Computers and Electronics
• Internet
• Website Application Instructions
• Google Applications
• Google Docs

wikiHow Newsletter You're all set! Helpful how-tos delivered toyour inbox every week! Sign me up! By signing up you are agreeing to receive emails according to our privacy policy.

• Home
• About wikiHow
• Experts
• Jobs
• Contact Us
• Site Map
• Terms of Use
• Privacy Policy
• Do Not Sell or Share My Info
• Not Selling Info
• Contribute

Follow Us

×

Keep up with the latest tech with wikiHow's free Tech Help Newsletter

Subscribe You're all set! X --543