Filter Views in Google Sheets: Explained
In this article, you will learn what Filter Views is and how to use them in Google Sheets. It is beneficial when looking at relevant items or having a sorted list of items in a large volume of data because the function has various options to sort objects and show things that meet a criterion.
How to use Filter View in Google Sheets
- Prepare a data set ideally with table headers and select its entire range
- Go to the “Data” tab → “Filter views” → “Create new filter view”.
- Navigate to the column header based on which you want to sort.
- Click the icon shaped like an inverted triangle next to the header.
- Define how to sort the column in the menu and click the “OK” button.
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.
How to save, switch, edit, duplicate and delete Filter Views in Google Sheets
Save: The filter views you create are automatically saved.
Switch: Click the “Data” tab → “Filter views” → click the name of the filter view you want to apply
The following actions must be taken when you apply the filter you want to rename, update, duplicate or delete.
Rename: Go to the top left corner of the filter window and click the text box next to “Name” or navigate to the top right corner and click the gear icon → “Rename”. Also, you can move to the “Data” tab → “Filter views” → “Filter view options” → “Rename”.
Update Range: Go to the top of the filter window and click the text box next to “Range” or navigate to the top right corner and click the gear icon → “Update range”. Also, you can move to the “Data” tab → “Filter views” → “Filter view options” → “Update range”.
Duplicate: Navigate to the top right corner and click the gear icon → “Duplicate”. Another way is to move to the “Data” tab → “Filter views” → “Filter view options” → “Duplicate”.
Delete: Click the gear icon at the top right corner of the filter view window → “Delete”. Another way is to move to the “Data” tab → “Filter views” → “Filter view options” → “Delete”. If you want to delete all filter views, click “Delete all filter views” under the “Filter view options”.
What is the difference between a filter and Filter Views in Google Sheets?
A filter and filter view are similar in enabling you to sort and analyze data efficiently. However, filter view has more diverse functions, though a filter is simple and handy enough to use quickly.
- Show a particular filter when your collaborators look at a worksheet.
- Sort your data set with a filter setting.
Filter views can:
- Allow you to save more than one filter setting.
- Name filters you create.
- Enable multiple collaborators to see different filters simultaneously.
- Allow you to share them with other people.
- Create copies of them or ones with similar settings
- Enable you to create a temporary filter view to sort data on a spreadsheet you don’t have access to. (This temporary filter view will not be automatically saved)
Can you share filter views with other collaborators in Google Sheets?
Yes, you can. Each filter view generates a slightly different link from the original worksheet. Copy the link when the filter view you want to share is applied and send it to your collaborators.
Can you filter Google Sheets without affecting other users?
Yes, as explained in the section above, “What is the difference between a filter and filter view in Google Sheets?”, filter view (not a filter) allows people on the worksheet to look at different filters at the same time.