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.

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.

Editors' Recommendations

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…
How to appear offline on Discord on desktop and mobile
Gamer using Discord on a gaming desktop PC.

One of the reasons Discord remains a popular platform is because it’s so easy to communicate with the groups and servers you want, moving between communities and choosing text or voice chatting depending on what you’re in the mood for. But sometimes you’re not in the mood for anything, and would rather just appear offline so you aren't bothered.

Read more
How to create a Subreddit on desktop and mobile
Laptop Working from Home

Few social media sites are as popular as Reddit. Regardless of what you're interested in, there's probably a thriving community for you to interact with on the platform. Known as subreddits, these communities are home to topics like gaming, world news, science, movies, and more. If you can't find a subreddit with your particular interest, Reddit makes it easy to create your own Reddit community.

Running a successful Reddit community isn't easy – but the process of starting one only takes a few minutes. Keep in mind that you'll want to keep a close eye on your subreddit to prevent it from being shut down or turning into a wasteland with no users, but running a subreddit can be a lot of fun when done properly. If you prefer, you can also create a private community that only your friends can join, giving you a place to hang out beyond Twitter and TikTok.

Read more
How to convert a PowerPoint to Google Slides
Speaker notes in Presenter View in PowerPoint on a Dell monitor.

While PowerPoint is widely used to develop presentations, Google Slides has become a popular alternative. Part of what makes it so popular is that it's free to use, as is other Google software such as Google Docs and Google Sheets – which is a stark contrast to the premium price you'll pay for Microsoft Office and PowerPoint.

If you're looking to jump ship from PowerPoint to Slides, Google makes it easy to do so. In fact, it takes little more than a few clicks to convert a PowerPoint to Google Slides. Whether you need to change the format for a coworker or want to permanently switch to the free platform, here's a look at how to convert your PowerPoint deck into a Google Slides presentation.

Read more