In this article, you will learn what a filter is and how to use them in Google Sheets. A filter is beneficial when you want to look at relevant items or have a sorted list of items in a large volume of data because the function has various options to re-order items and show things that meet a criterion. If you want to save and share the filter you create, you should use Filter Views instead.
When you click the reverse triangle icon, you will see the filtering menu, as shown below.
Sort A → Z: You can reorder items in alphabetical order
Sort Z → A: Things are rearranged in reverse alphabetical order
Sort by color (Fill color): The values are sorted based on cell colors - conditional formatting colors work for this filter, but alternating colors do not.
Sort by color (Text color): You can organize data based on text colors
Filter by condition: The items are selected by one of the default conditions relevant to text, date, and number (e.g., “Text contains”, “Date is”, and “Greater than”) or your own rule defined under “Custom formula is”.
Filter by values: The values are shown when the boxes next to them are checked and hidden if they are unchecked.
Lastly, look at the example below. Assume you have the following records. You want to focus on people from the “North” country.
Note: Look at “Select all” and “Clear” beneath “Filter by values”. If you click “Select all”, all boxes are checked. On the other hand, if you click “Clear”, all checkboxes are unchecked. They are helpful when you want to check or uncheck multiple items.
The following screenshot shows the filtered result. As you can see, the inverted triangle has turned into a funnel icon, which means the column is filtered.
If you want to delete the filter, navigate to the “Data” tab → “Remove filter”.
Yes, you can. Navigate to “Click Data” → “Filter views” → “Save as filter view”. Check this article to learn Filter View and how to use it.
When you create a filter, collaborators who have access to a worksheet can see the filter. Also, collaborators who have permission to edit the spreadsheet can change the filter setting.
If you don’t get the right answer to your question in this article or you have other questions related to filtering, you may find the answers in the following articles.
Formulas for filtering
FILTER Function in Google Sheets: Explained - show values that meet the criteria defined
UNIQUE Function in Google Sheets: Explained - show unique values without duplications
Google Sheets’ functions for filtering
Filter Views in Google Sheets: Explained - sort items and share the filter with your collaborators
Learn how to do this step-by-step in the video below 👇