Skip to main content

How to search in Google Sheets

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.

Related Videos

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.

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.

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.

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.

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.

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.

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.

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.

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.

Editors' Recommendations

ChatGPT just plugged itself into the internet. What happens next?
OpenAI's website open on a MacBook, showing ChatGPT plugins.

OpenAI just announced that ChatGPT is getting even more powerful with plugins that allow the AI to access portions of the internet. This expansion could simplify tasks like shopping and planning trips without the need to access various websites for research.

This new web integration is in testing with select partners at the moment. The list includes Expedia, FiscalNote, Instacart, Kayak, Klarna, Milo, OpenTable, Shopify, Slack, Speak, Wolfram, and Zapier.

Read more
Best laptop deals: Save on Apple, Dell, HP and Lenovo
The ThinkPad X1 Carbon Gen 10 laptop, opened with a colorful wallpaper on the screen.

Everybody has different requirements from the laptops that they buy. Students need reliability to help with their schoolwork, professionals desire lag-free performance for their daily workload, and gamers aim to be able to play the latest video games. Fortunately, there are laptop deals for every situation -- you just need to make the right choice, depending on what you want out of your new device. However, since there's no shortage of options that involve the best laptop brands such as HP, Dell, Lenovo, and Apple, that's easier said than done. To help you with your decision, we've gathered the best laptop deals that you can shop right now.
LG gram Style 16 – $1,800, was $2,000

Beautiful. Inspired. Lightweight. LG’s gram Style is a 16-inch laptop with an OLED display, lots of power under the hood, and a sleek profile that will catch everyone’s eye. It features a 13th Gen Intel Core i7 Evo processor, 32GB of the blazing fast LPDDR5 RAM, Intel Iris XE graphics, and a 1TB PCIe Gen 4  NVMe solid-state drive. All of that works together to seamlessly provide a powerful multi-tasking experience anywhere you need to be. The display supports a 100% DCI-P3 color gamut and VESA DisplayHDR 500 with true blacks for incredible visual fidelity, plus you get 360-degree surround audio with Dolby Atmos. It’s ideal for watching streaming media, getting some work or schoolwork done, casual browsing and playing, and much more.

Read more
ChatGPT: how to use the viral AI chatbot that everyone’s talking about
ChatGPT and OpenAI logos.

ChatGPT has continued to dazzle the internet with AI-generated content, morphing from a novel chatbot into a piece of technology that is driving the next era of technological innovation. Not everyone's on board yet, though, and you're probably wondering; what's all the fuss about?

It's made by OpenAI, well-known for having developed the text-to-image generator DALL-E, and it's currently available for anyone to try out for free. Here's what ChatGPT is, how to use it, and how it could change the future of the internet.

Read more