Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to create and use Filter Views in Google Sheets.
How To Create & Use Filter Views in Google Sheets
Google Sheets allows you to create and use filter views to quickly and easily view different subsets of data from your spreadsheets. Filter views allow you to create custom views of data, which can be filtered and sorted in different ways.
An advantage of using filter views is that it allows us to create multiple views of our data without making any changes to the underlying data.
For example, you may want to filter a spreadsheet to only show rows that contain certain keywords. Or, you may want to sort a column in a certain order. Filter views allow multiple users to work with the same data while having the freedom to only see the entries and fields relevant to them.
In this guide, we will show you how to create and use filter views in Google Sheets.
How To Add Your Own Filter View in Google Sheets
Here’s how to add your own filter view in Google Sheets.
Select the dataset range you want to create a filter view with.
In this example, we will create a filter view out of sales data for a range of electronics products.
Next, select Data > Filter views > Create new filter view.
You should now have a filter view of the currently-selected cell range. The black row and column headers indicate that you are currently viewing a filter view.
You have the option to add a descriptive name for the current filter view. This is useful if you will end up creating more than one filter view for a dataset.
Apply various filters to the target range while the filter view is activated.
In this example, we want to add a filter to only show items with a sales count higher than 75.
You can click on the exit icon on the top-right to exit the filter view.
The underlying data should remain unedited.
This guide should be everything you need to use filter views in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.