Searching for specific information can be a hindrance when working with large sheets containing a lot of data. In this guide, I’ll show you how to quickly search in Google Sheets to find any information you need.
Use the Quick Find Tool to Search
You can use the Quick Find Tool shortcut to search in Google Sheets. To use this feature, follow these steps:
- Press the following key bindings:
Ctrl + F (for Windows users)
Cmd + F ( for macOS users) - You will notice a search field in the top-right. Enter the text that you want to find in the Find field.
Enter the text you want to search in the quick find tool. - It will automatically highlight the cells containing the text you entered. Use the arrows next to the text box to navigate through all the highlighted cells.
Use the up and down arrow keys to navigate the search results.
Use the Find and replace tool
You can use the Find and Replace tool to search for a value within a specified section of the sheet and across multiple sheets. Follow these steps:
- Click on Edit in the top menu and select Find and replace.Alternatively, press Ctrl + H (for Windows users) or Cmd + Shift + H (for macOS users).
From the Edit menu, choose Find and replace. - Next to the Find text field, type the text you want to search for. To control which sheet you want to search the text in, click on the Sheets dropdown. You can select All sheets to search for values in the entire workbook. Finally, click on Find.
Enter the search query in the Find field. - Click on the Find button multiple times to navigate through the search results.
Navigate the search results by pressing the Find button multiple times.
Use the Conditional Formatting tool
Conditional formatting allows you to highlight cells for the searched text. To use this feature, follow these steps:
- Go to Format > Conditional Formatting.
Go to Conditional formatting. - In the “Apply to range” field, enter the range of cells you want to search in, or select the range of cells using your cursor.
- Click OK in the “Select a date range” pop-up.
Click OK. - Under “Format rules,” click on the Format cells if dropdown and choose Text Contains.
Choose Text contains. - Enter the text you want to search for in the defined range. Then, click Done.
Enter the text you want to search for. - You will find the searched text highlighted in the given range.
Search results are highlighted.
Use Filters to search within a specific column
To search in a particular column, you can use the Filter feature:
- Go to Data in the top menu, and select Create a filter.
From the Data menu, select Create a filter. Alternatively, click on Create a filter button from the toolbar.
Choose Create a filter. - Left-click on the filter icon in the header for the column you want to search. For example, I want to search “United States” in the column “Country.”
Click on the Filter icon on the column header. - Click on the Clear option.
Click on Clear. - Type the text you want to search for in that column. Then, press OK.
Enter the text you want to search. - You will notice only the searched text in the filtered column.
Search results using the Filter tool.
Use the SEARCH function to search within cells
The SEARCH function allows you to search for text within a cell or range of cells. To use this function, follow these steps:
- Enter the SEARCH function into a cell.
Enter the Search Function by typing “=SEARCH”. - Enter the text you want to search for within the parentheses. Then, enter the cell or range of cells you want to search. In this example, I’m searching for the “Khosi” in cell G3.
Within the parentheses, enter the text and the range to search for. - Hit Enter. The SEARCH function will return the position of the text you are searching for. In our example, if the text is found in the first position, the function will return a value of 1.
It will return the position of the text you are searching for.