Google Sheets are managing a lot of data which consists of hundreds of rows and columns. If someone is supposed to find a specific word or phrase, then the person is supposed to go through all the rows and columns and this process is time-consuming as well as effort is required.
This article will explain the most efficient Search methods for finding specific information faster and in less time.
Why do We need to Search on Google Sheets?
We know that Google Sheets contain data comprising many rows and columns. If any information is needed, we can find its location where it exists. There are many other reasons for searching in Google Sheets:
- To find out specific values or text in Google Sheets
- To analyze the trends, for example, we can apply different functions to find out the sales of the particular region
- If an error occurs, we can use the search feature to locate the error
- If you are working with large data sets, then it will save your time
How to Efficiently Search on Google Sheets?
There are two most convenient methods of searching the data efficiently on Google Sheets:
- Using the Keyboard Shortcut of Google Sheets
- Using the Conditional formatting in Google Sheets
Method 1: Using the Keyboard Shortcut of Google Sheets
The simplest way to search the text or number in Google Sheets is by using the keyboard shortcut key “CTRL+F” if you are using the Windows OS and if you are using the MacOS then use the “CMD+F”. A search text box appears, type the number or text which is supposed to be searched and press the ENTER key. For example, in the Google Sheet of “Students Result”, we will find the name of “Paul”. Use the CTRL+F as we are using the Windows Operating System:
Type the “Paul” and then press the ENTER key:
The “ 1 of 2” means “Paul” is located at two different positions which can find out with the help of the arrows:
To close the search box, click on the “X”:
This method is the most convenient method of searching the text or numbers on Google Sheets.
Method 2: Using the Conditional formatting in Google Sheets
Another method of searching the text and number is by using conditional formatting. For example, we want to search “Paul”, then we will select the “Student Name”:
Then click on “Format” and then “Conditional formatting”:
In the new menu of “Conditional format rules” choose “Text contains” in “Format rules”:
Type the “Paul” in the value box and then click on “Done”:
The text of “Paul” is highlighted in the Google Sheet:
This is the method of searching the text or number by highlighting them in Google Sheets.
To efficiently search texts or numbers in Google Sheets either use the shortcut key of “CTRL+F” or use “Conditional formatting”. Both methods are explained in the blog with a simple demonstration of the example.