How to use Filter views in Google Sheets | Simple 2-min Guide 💻

Reading Time: 3 minutes

Lesson: Use Filter views in Google Sheets

Learn how to use Filter view in Google Sheets and its variations.

Why use Filtered views in Google Sheets?

Analysing data tables can be a tedious task. Using filters, you can look at data of your choice, thereby making data analysis easier. However, if you change the filter parameters, a new filtered dataset will appear, and the previously filtered data will disappear. You can save filtered data in a filtered view and can move on to make more filtered views and store the previously made filtered datasets.

How to use Filter view?

Step 1: Select your dataset

  • Open Google Sheets.
  • Press Ctrl + A (Windows) or Cmd + A (Mac) to select the dataset.

Select dataset of interest
Figure 1: Select dataset of interest

Step 2: Go to Data –> Filter Views –> Create Filter View

  • Navigate to the Data button in the menu toolbar.
  • Select Filter Views → Create new filter view.

Navigate to Create new filter view
Figure 2: Navigate to Create new filter view

Step 3: Filter dataset and Create a New Filter View

  • Filter the dataset as per your requirement.
  • Here, I am choosing to look at data where Quarter=Q1.

Select your filter
Figure 3: Select your filter
  • The output is all rows where Quarter=Q1. We name this view Filter 1.

Filtered view
Figure 4: Filtered view
  • Now, let’s create another filter view.
  • Navigate to the Data button in the menu toolbar.
  • Select Filter Views → Create new filter view.

Create new filtered view
Figure 5: Create new filtered view
  • Make sure that the range is the same as you had previously selected.
  • Now create a filter as per your requirement.
  • Here, I am choosing to look at data where Region=India.

Choose your filter
Figure 6: Choose your filter
  • The output is all rows where Region=India, irrespective of other parameters. We name this view Filter 2.

Filtered view
Figure 7: Filtered view
  • If you now go to Data → Filter Views → Create new filter view, you can see that Filter 1 and Filter 2 are available in the Filter menu.
  • You can navigate between these views, or create new views, as per convenience.

All filter views created
Figure 8: All filter views created

See Also

Conditional Formatting in Google Sheets: Get started with Conditional Formatting in Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial