How to Create a Filter View on Google Sheets

Author Info

Last Updated: June 24, 2019 Tested

Filter views can help you review and analyze data in Google Sheets. A regular filter hides the data you've filtered out for all people viewing your Sheet, whereas a filter view allows you to save multiple filters, view filtered data without affecting what others see, and even share links to specific filter views with different people.^{[1]
X
Research source}

Steps

Download Article

If you don't select the full range now, don't worry, because you can adjust it later.

Advertisement
3
Select the arrow next to the filter icon in the toolbar. Then select Create new filter view.
- You can also get there by hitting Data > Filter Views > Create new filter view in the toolbar menu.
4
Adjust the filter name and range, if desired.
- You can name your filter so that you and others can more easily access it later.
- You can also adjust the range for the filter; for example, if you want to exclude your header rows from the data, you can start the range on the last line of your header. If you want to select multiple columns, you can do that, too.
6
Select your filter type. You can decide to Filter by condition or Filter by values.
- Filtering by condition allows you to pick a condition for the displayed data. For example, if you choose Cell is empty, only empty cells will be shown. If you choose Cell is not empty, only cells with data in them will be shown.
- Filtering by value allows you to select which values you keep. If an item has a checkmark next to it, that cells with that value will be displayed; if you remove the checkmark, the cells with that value will be hidden.
You'll see the results of your filtering right away. You can keep filtering different columns and adjusting your filters as you want to, all within the same filter view.
From there, you can rename the filter, adjust the range, duplicate it, or delete it.
The filter will still be saved for future use, unless you manually delete it.
From that menu, you can select the filter by the name you gave it earlier.

Expert Q&A

Search

Add New Question

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Tips

If you want to filter multiple data in multiple columns, you can select a range that includes all the relevant columns, and then filter each column by whichever rules you choose, all within one filter view.

Thanks
Helpful 0 Not Helpful 0