How to Create a Filter View on Google Sheets

wikiHow is a “wiki,” similar to Wikipedia, which means that many of our articles are co-written by multiple authors. To create this article, volunteer authors worked to edit and improve it over time.

The wikiHow Tech Team also followed the article's instructions and verified that they work.

This article has been viewed 30,075 times.

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

Fair Use (screenshot)
\n"> Open up the Google Sheet with the data you want to review.

Fair Use (screenshot)
\n">

Select the range of data that you want to filter. If you don't select the full range now, don't worry, because you can adjust it later.

Fair Use (screenshot)
\n">

You can also get there by hitting Data >Filter Views >Create new filter view in the toolbar menu.

Fair Use (screenshot)
\n">

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.

Fair Use (screenshot)
\n"> Hit the small filter icon at the top of the column for the data you selected.

Fair Use (screenshot)
\n">

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.

Fair Use (screenshot)
\n">

Hit OK once you've selected your desired filter settings. 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.

Fair Use (screenshot)
\n">

Select the cog in the righthand corner of the filter if you want to change the settings. From there, you can rename the filter, adjust the range, duplicate it, or delete it.

Fair Use (screenshot)
\n">

Hit the "X" if you want to close your filter view. The filter will still be saved for future use, unless you manually delete it.

Fair Use (screenshot)
\n">

Access the filter again by hitting the arrow next to the filter icon in the toolbar. From that menu, you can select the filter by the name you gave it earlier.

Expert Q&A

Ask a Question 200 characters left Include your email address to get a message when this question is answered. Advertisement

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.

Submit a Tip All tip submissions are carefully reviewed before being published Please provide your name and last initial Thanks for submitting a tip for review!