How to Search in Google Sheets (Two Ways!)

May 30, 2021

You can search a Google Sheet the same you would search a Google Doc, which is to say you simply press Cmd + F and enter your search term.

But just in case you need further help, we'll show you another way to find things in a Google Sheet as well.

If you want to optimize your workflow, take a moment to review the latest list of keyboard shortcuts in Google Sheets.

Google Workspace

Howchoo is reader-supported. As an Amazon Associate, we may earn a small affiliate commission at no cost to you when you buy through our links.

When you press cmd + F on your keyboard, a search box will pop up on the upper-right side of your page. Enter your search term there. Google Sheets will highlight any matching terms in your spreadsheet.

If, instead, you want to search for and replace particular values or text, then you can use the find and replace function built into Google Sheets.

Go to Edit.
Choose Find and replace.

Now, input the value or phrase you want to find in the "Find" text box. Then, input what you want to replace it with in the "Replace with" text box.

Select Replace all.

NEXT UP

Michael (175)

Apr 19, 2021

For anyone who has decided to switch over to Google Workspace, they might find they have a bunch of Excel spreadsheets that they need to transfer first.