Search in Google Sheets





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.

The Search and Replace field in Google Sheets used to search.

Step 3: Within the Find enter the number or word you want to search for.

The search box in Google Sheets used for entering a search term.

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

The different search options in Google Sheets.

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.

The Search Google Sheets button and how Google displays that search.

Find formulas

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.

The Also Search Formulas box in Google Sheets.

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.

Find a formula in Google Sheets.

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.

The shortcut to search in Google Sheets.

Step 2: If you want to open Find and replace use the instead CTRLShifthuh keyboard combination on Windows or AssignmentcmdShifthuh on a Mac.

The shortcut to open the Search and Replace window in Google Sheets.

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.

Editor’s Recommendations









Leave a Comment

x