Skip to main content

How to search in Google Sheets

google search engine private alternatives brave neeva duckduckgo person using on a laptop
Firmbee.com/Unsplash

If you’re working on spreadsheets via Google Sheets where you’re finding it difficult to locate words, numbers, or formulas, then there’s an easy solution to find what you’re looking for. Let’s take a look at how to search in Google Sheets.

Difficulty

Easy

Duration

5 minutes

What You Need

  • A computer, laptop, tablet, or phone with access to Google Sheets

Using the Find and Replace tool

Step 1: Open your Google Sheets spreadsheet and then select the Edit tab adjacent to File.

Step 2: Click the Find and replace field.

The Find and replace field in Google Sheets used for searching.
Image used with permission by copyright holder

Step 3: Within the Find box, enter the number or word you want to search for.

The Find box in Google Sheets used for entering a search term.
Image used with permission by copyright holder

Step 4: Within the Search drop-down box, you can initiate the search to be applied to all your sheets within that file via All sheets. You can also search within This sheet or a Specific range.

The different Search options in Google Sheets.
Image used with permission by copyright holder

Step 5: Once you’ve selected an option from that drop-down menu, click the Find button.

Google will display the word or number you searched for by applying a blue border around the cell it’s inserted in.

The Find button in Google Sheets and how Google displays that search.
Image used with permission by copyright holder

How to search for formulas

If you’re searching for a formula instead of a word or number, Google provides an option to do so.

Step 1: Click Edit and then select Find and Replace.

Step 2: Tick the Also search within formulas box.

The Also search within formulas box in Google Sheets.
Image used with permission by copyright holder

Step 3: In the Find box, enter the formula you want to search for. You can search for the entire formula or you can search for a certain formula by only typing the first part of that formula. For example, I included the result for =sum in the image below. Click the Find button.

Searching for a formula in Google Sheets.
Image used with permission by copyright holder

What is the shortcut for search in Google Sheets?

Step 1: When you have your spreadsheet open, use the CTRL button and F keyboard combination to open a search box.

The shortcut to search in Google Sheets.
Image used with permission by copyright holder

Step 2: If you want to open Find and replace instead, use the CTRL + Shift + H keyboard combination on Windows or Command (cmd) + Shift + H on a Mac.

The shortcut to open the Find and replace window in Google Sheets.
Image used with permission by copyright holder

For more on Google Sheets, head over to our guide on how to make a graph or chart, as well our tutorial on how to lock cells in Google Sheets.

Zak Islam
Former Digital Trends Contributor
Zak Islam was a freelance writer at Digital Trends covering the latest news in the technology world, particularly the…
Google is bringing AI to the classroom — in a big way
a teacher teaching teens

Google is already incorporating its Gemini AI assistant into the rest of its product ecosystem to help individuals and businesses streamline their existing workflows. Now, the Silicon Valley titan is looking to bring AI into the classroom.
While we've already seen the damage that teens can do when given access to generative AI, Google argues that it is taking steps to ensure the technology is employed responsibly by students and academic faculty alike.
Following last year's initial rollout of a teen-safe version of Gemini for personal use, the company at the time decided to not enable the AI's use with school-issued accounts. That will change in the coming months as Google makes the AI available free of charge to students in over 100 countries though its Google Workspace for Education accounts and school-issued Chromebooks.
Teens that meet Google's minimum age requirements -- they have to be 13 or older in the U.S., 18 or over in the European Economic Area (EEA), Switzerland, Canada, and the U.K. -- will be able to converse with Gemini as they would on their personal accounts. That includes access to features like Help me write, Help me read, generative AI backgrounds, and AI-powered noise cancellation. The company was quick to point out that no personal data from this program will be used to train AI models, and that school administrators will be granted admin access to implement or remove features as needed.
What's more, teens will be able to organize and track their homework assignments through Google Task and Calendar integrations as well as collaborate with their peers using Meet and Assignments.
Google Classroom will also integrate with the school's Student Information System (SIS), allowing educators to set up classes and import pertinent data such as student lists and grading settings. They'll also have access to an expanded Google for Education App Hub with 16 new app integrations including Kami, Quizizz, and Screencastify available at launch.
Students will also have access to the Read Along in Classroom feature, which provides them with real-time, AI-based reading help. Conversely, educators will receive feedback from the AI on the student's reading accuracy, speed, and comprehension.
In the coming months, Google also hopes to introduce the ability for teachers to generate personalized stories tailored to each student's specific education needs. The feature is currently available in English, with more than 800 books for teachers to choose from, though it will soon offer support for other languages, starting with Spanish.
Additionally, Google is piloting a suite of Gemini in Classroom tools that will enable teachers to "define groups of students in Classroom to assign different content based on each group’s needs." The recently announced Google Vids, which helps users quickly and easily cut together engaging video clips, will be coming to the classroom as well. A non-AI version of Vids arrives on Google Workspace for Education Plus later this year, while the AI-enhanced version will only be available as a Workspace add-on.
That said, Google has apparently not forgotten just how emotionally vicious teenagers can be. As such, the company is incorporating a number of safety and privacy tools into the new AI system. For example, school administrators will be empowered to prevent students from initiating direct messages and creating spaces to hinder bullying.
Admins will also have the option to block access to Classroom from compromised Android and iOS devices, and can require multiparty approval (i.e. at least two school officials) before security-sensitive changes (like turning off two-step authentication) can be implemented.
Google is introducing a slew of accessibility features as well. Chromebooks will get a new Read Aloud feature in the Chrome browser, for example. Extract Text from PDF will leverage OCR technology to make PDFs accessible to screen readers through the Chrome browser, while the Files app will soon offer augmented image labels to assist screen readers with relaying the contents of images in Chrome.
Later this year, Google also plans to release a feature that will allow users to control their Chromebooks using only their facial expressions and head movements.
These features all sound impressive and should help bring AI into the classroom in a safe and responsible manner -- in theory, at least. Though given how quickly today's teens can exploit security loopholes to bypass their school's web filters, Google's good intentions could ultimately prove insufficient.

Read more
I compared ChatGPT against Google Gemini to see which is the better free AI chatbot
A person typing on a laptop that is showing the ChatGPT generative AI website.

Two of the leading AI chatbots available today come from Google, with its Gemini system, and OpenAI, the company that kicked off the AI revolution with ChatGPT.
But you might be wondering which is the better free chatbot. I've spent a significant time with both to see how they compare, break down the costs and benefits of each service, explain what features you'll have to pay for and which you get for free, and show you which AI is best for what you need.

Pricing and tiers
Both ChatGPT and Gemini are available to the public for free at their respective websites and through their mobile apps. However, free tier users will only receive limited access to the most current and capable models.

Read more
Google’s new AI generates audio soundtracks from pixels
An AI generated wolf howling

Deep Mind showed off the latest results from its generative AI video-to-audio research on Tuesday. It's a novel system that combines what it sees on-screen with the user's written prompt to create synced audio soundscapes for a given video clip.

The V2A AI can be paired with vide -generation models like Veo, Deep Mind's generative audio team wrote in a blog post, and can create soundtracks, sound effects, and even dialogue for the on-screen action. What's more, Deep Mind claims that its new system can generate "an unlimited number of soundtracks for any video input" by tuning the model with positive and negative prompts that encourage or discourage the use of a particular sound, respectively.

Read more