When you have to find specific data in a spreadsheet full of data, filters in Google Sheet can help. All you have to do is enter a number of criteria for the data you need to see the results with a few clicks. In this article, we want to review the basics of applying a few simple filters in Google Sheet.
Activate the filter in Google Sheet
You can use the filter feature in Google Sheet immediately after activating it. When the filter is activated, a filter icon is displayed above the columns containing the data, with the help of which you can filter any column you need.
Depending on how you configure it, you may need to select a cell in your datasheet area. For example, if you have blocks of data separated by empty columns, select the cell in the block to which you want to filter.
If you want to be able to filter each column in the sheet, you have to select the whole sheet by clicking on the rectangle at the top left (where A and 1 meet).
Go to the right side of the toolbar and click Create a Filter .
You are now ready to apply a filter. You can apply the filter based on color, conditions or values.
Filter by color
If you use color in your spreadsheet to highlight text or cells, you can apply the filter based on the colors you use.
Click the filter icon next to the title of the column you want to filter. Hover over the Filter by Color, select Fill Color or Text Color, and then select a color from the drop-down menu.
Your sheet will be updated with the filtered data and the remaining data will be hidden in the column.
Filter by condition
You may want to filter out empty cells or those that contain text, dates, numbers, or special formulas. Filtering by condition, all of these options along with the specifications of each gives you a valley.
For example, you can filter text that starts or ends with a specific letter, dates that are before or after another date, or numbers that are greater than or less than a certain value.
Click on the filter icon in the column header and open Filtering by condition .
In the drop-down box, select the condition.
In this example, we filter the numbers that are Greater Than (Equal to) or Equal To (equal to) 250.
Therefore, after selecting the condition, you must enter a value or formula in the box just below it. Click OK to apply the filter .
Only values greater than or equal to 250 are now displayed in our selected column.
Filter by values
One of the ultimate ways to filter data in Google Sheet is by Filter by Values. When you use this filter, the sheet only shows you the values in that column, so you can select the values you want to see in the list or use the search box to quickly find the value you want.
Click the filter icon in the column title and expand the Filter by Values list. Depending on the amount of data you have in the column, you may want to use the Select All or Clear options. Then select or deselect only the items you want.
You can also scroll down the list of data and mark or uncheck the values in it, or find an existing value in the search box. Click OK to apply the filter. In this example, we wanted to filter the April and August values.
Your sheet is updated to show only the data in the filter and hide the rest.
Disable the filter in Google Sheet
Unlike Microsoft Excel filters, Google Sheets does not currently offer a one-click way to clear filters. So, once you have finished using the filter, you can simply disable it the same way you activated it.
Go to the right side of the toolbar and click Turn Off Filter .
We hope you find this tutorial useful. As always, you can share your questions with us and Wironal users from the comments section.