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

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

One response to “How to use Filter views in Google Sheets | Simple 2-min Guide 💻”

  1. […] When you have a lot of data, let’s say 1000000 rows in your table and you only want to perform calculations on a subset of data. For example, you have a list of orders and you want to perform calculations on an order with a price above some specific amount. It is a good idea to use a Filter in these cases. Not only does it become easier to work with, but it also reduces the load on the server, hence eliminating the possibility of slow Google Sheets. You can check out an amazing article on using Filter in Google Sheets here. […]

Leave a Reply