If you’re working on spreadsheets through Google Sheets and have a hard time finding words, numbers, or formulas, there’s an easy way to find what you’re looking for. Let’s take a look at how to search Google Sheets.
Using the Find and Replace tool
Step 1: Open your Google Sheets spreadsheet and then select the edit tab next to File†
Step 2: Click on the Find and replace field.
Step 3: Within the Find enter the number or word you want to search for.
Step 4: Within the Search drop-down list, you can start the search to be applied to all your worksheets in that file via All sheets† You can also search within this sheet or a Specific range†
Step 5: After selecting an option from that drop-down menu, click the Find knob.
Google displays the word or number you’ve searched for by applying a blue border around the cell it’s inserted into.
If you’re looking 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.
Step 3: In the Find enter the formula you want to search for. You can search for the entire formula or you can search for a particular formula by typing only the first part of that formula. For example, I recorded the result for: =sum in the image below. Click on the Find knob.
What is the shortcut for search in Google Sheets?
Step 1: Once you have your spreadsheet open, use the CTRL button and f keyboard combination to open a search box.
Step 2: If you want to open Find and replace use the instead CTRL † Shift † huh keyboard combination on Windows or Assignment †cmd† Shift † huh on a Mac.
To learn more about Google Sheets, check out our guide on how to create a chart or diagram, as well as our tutorial on how to lock cells in Google Sheets.