How to search in Google Sheets

How to Use XLOOKUP in Google Sheets
How to search in Google Sheets (Image credit: Shutterstock)

"How to search in Google Sheets" is a search query that's gaining traction as we speak, and quite frankly, I don't blame 'em! Who wants to sift through an exhaustive, encyclopedic list of junk on a Google Sheet? After all, there is an easier way.

If you're interested on how you can work smarter, not harder, here is a step-by-step guide on how to search in Google Sheets.

How to search in Google Sheets

The fastest way to search in Google Sheets is to use a shortcut. 

1. Open up the Google Sheet you'd like to search in.

2. If you're on Windows, use CTRL + F.  On a Mac? Use Command + F.

How to search in Google Sheets

(Image credit: Future)

3. In the top-right corner, a small search field should appear. Type in your search query and you should find what you need in no time.

How to search in Google Sheets

How to search in Google Sheets (Image credit: Future)

4. If you prefer a more labyrinthine method (not sure why you would, but I'll play along), you can head to Edit > Find and replace.

How to search in Google Sheets

How to search in Google Sheets (Image credit: Future)

5. Type in your search query, select This Sheet in the drop-down menu, and click on Find.

That's all there is to it, enjoy your newfound Sheets searching skills.

Kimberly Gedeon

Kimberly Gedeon, holding a Master's degree in International Journalism, launched her career as a journalist for MadameNoire's business beat in 2013. She loved translating stuffy stories about the economy, personal finance and investing into digestible, easy-to-understand, entertaining stories for young women of color. During her time on the business beat, she discovered her passion for tech as she dove into articles about tech entrepreneurship, the Consumer Electronics Show (CES) and the latest tablets. After eight years of freelancing, dabbling in a myriad of beats, she's finally found a home at Laptop Mag that accepts her as the crypto-addicted, virtual reality-loving, investing-focused, tech-fascinated nerd she is. Woot!

Read more
chatgpt search feature
There are now 3 great reasons to switch from Google Search to ChatGPT Search
Error when installing Google Chrome on the Asus Vivobook 16 Flip, on a white desk against a blue background.
"This app can't run on your PC": Google's Chrome Installer broke on Windows, but there's a fix
Microsoft Office
Microsoft's recent tests could lure Google Workspace users back to Office apps
Samsung Galaxy Chromebook Plus
Best Chromebooks in 2025: 5 top picks tested and reviewed
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.
I found an app that connects all my apps — without trying to replace them. It's a life-changer.
The Acer Chromebook Plus Enterprise 515 playing a movie trailer, on a black desk against a white background.
Turn your Chromebook into a business laptop, for free
Latest in Work & Collaboration Tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.
I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction
Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
The 39.7-inch Dell UltraSharp monitor beside a Laptop Mag deals icon in front of an orange and yellow background
Top 5 Dell UltraSharp monitor deals: Save up to $300 on the ultimate productivity monitor!
The Logitech MX Creative Console seen from above on a white table
Logitech MX Creative Console review: Is this alternative stream deck a creative game changer?
Google Search
Google Reverse Image Search: How to search with an image in Google
docs in proton drive
What is Proton Docs? Why you might want to give the privacy-focused Google competitor a chance
Latest in How-To
illustration of laptop with tower speakers on either side.
How I turned my office into a personal concert hall with tower speakers and a MacBook
Acer Predator Triton Neo 16 gaming and content creation laptop
3 critical tips and tricks for maximizing performance on your gaming laptop
Samsung Galaxy Chromebook Plus
How to restart a Chromebook
how to use copilot voice
Copilot Voice: Here's how you can chat with Microsoft's new AI companion
Screenshots of iPhone mirroring using iOS 18 and macOS Sequoia
iPhone Mirroring changed how I use my MacBook and iPhone — here's how it works
The iPhone 16's camera control button
How to use the iPhone 16's new Camera Control button to become a phone photography pro