Google Sheets Filters & Filter Views
This post will demonstrate how to properly use the Filter feature and create Filter Views in Google Sheets.
Filter Views can be saved and easily accessed later with a single click.
Another advantage is the ability to sort the data visually without changing the underlying physical order of the data.
When it comes to collaboration, multiple users can simultaneously filter the data in different ways without disrupting the view of other users.

Filtering allows us to display only records that meet specified criteria or criterion. This lets us focus on only specific records without the distraction of the entire dataset.
Activating Filters
To activate the Filter controls, select a cell within the desired table, and click Data -> Create a Filter.
This activates the filter controls within the header row of the selected table.
This can also be performed by clicking the Filter button on the far right of the toolbar.
Ensure there is at least 1 row of blank cells above your table, otherwise, the data range selection will extend beyond the header row.
Filter by Condition
By selecting a Filter control, we can also filter by a condition. These include conditions such as:
- Greater Than
- Less Than
- Includes/Excludes
- Between/Not Between
- Empty/Not Empty
- Starts With/Ends With
- Date In Range/Out of Range
- Date Before/After Filter by Color
If you have an applied font color or cell color, you can filter by either of these colors.
Filter Views
If you have data filtered, then sort the filtered results, the position of the records will change in the underlying table. This means when you remove the filter to display all records, portions of the original list will have changed.
To combat this, we can use what is known as Filter Views.
A Filter View behaves like a snapshot of the filtered data. Once activated, you can freely filter and sort the data as you wish without altering the original version of the data.
If you are collaborating with others, their version of the data remains unchanged as you filter and sort your perspective of the data.