How to☝️ Create and Use Filter Views in Google Sheets

To create and use Filter Views in Google Sheets, highlight your data, go to the Data menu, click on the Filter views option, and select Create new filter view. Next, tap on the Filter icon, check or uncheck the options you need to personalize your filter, and press OK.

Read on below to learn more about how to create a Filter View in Google Sheets in an easy and convenient way. This article will teach you how to use, save, share, and delete the Filter View. So, let’s get down to business!

What Is a Filter View?

A Filter View is a way to save your filter settings in Google Sheets. With this feature, you can quickly apply your custom filters without having to set it up every time.

Filter Views can be useful if you regularly need to filter your data in different ways. For example, you could create a Filter View for each month’s data or for data that meets certain criteria. 

What’s the Purpose of Filter Views in Google Sheets?

Filter Views in Google Sheets offer a way to view, manipulate, and analyze data stored in a spreadsheet without actually changing the underlying data.

This is useful for Google Sheets users who are dealing with the same data but who need to be able to make their own edits and changes to the data without disturbing others. This means that other users won’t be able to see the changes you’ve made, and you can easily work with your edits. It allows different team members to focus on different aspects of the data.

How to Create a Filter View in Google Sheets

Check out the step-by-step guide below to learn how to create a Filter View in seconds:

  1. Select the data.
  2. Navigate to the Data menu.
  3. Choose the Filter views option.
  4. Pick Create new filter view.

How to Create a Filter View in Google Sheets

Easy-peasy! That’s all it takes to create a new Filter View.

Filter View

Next, let’s learn how to use and modify it!

  1. Click on the Filter icon.
  2. Check or uncheck the options you need or experiment with the other actions available.
  3. Hit OK.

Filter

That’s it!

The Filter

How to Save a Filter View for Reuse

Once you’ve made changes in data using the filter, it’s saved automatically. But if you want to display the edited data in the list, take the following steps:

  1. Click on the Name box and enter a name for the filter.

How to Save a Filter View for Reuse

  1. Next, simply press the Enter key on your keyboard.

Easy as ABC! 

How to Find Your Saved Filter Views

If you want to use one of your previously saved Filter Views, take a look at this step-by-step guide on how to find them and apply them:

  1. Go to the Data menu.
  2. Choose the Filter views option.
  3. Select the filter you need.

How to Find Your Saved Filter Views

Voila! It’s that simple.

How to Share a Filter View with Others

If you want to share your Filter View with colleagues or friends, just do the following:

  1. After applying the Filter View, select the URL for your document.

How to Share a Filter View with Others

  1. Press the Ctrl + C (Windows) / Cmd + C (Mac OS) key combination to copy it.
  2. Share the document with other users by hitting the Ctrl + V / Cmd + V keys to paste it in a message to them.

That’s all it takes.

How to Delete a Filter View

Use the method below if you want to revert the document back to its original state:

  1. Navigate to the Data menu.
  2. Choose Filter views.
  3. Select Filter view options.
  4. Click Delete

How to Delete a Filter View

That’s it! The filter will be removed.

The Data

Can you lock a Filter View in Google Sheets?

Yes, you can lock a Filter View in Google Sheets. Here’s how you do it: 

  1. Select the range you need to protect.
  2. Right-click on it.
  3. Choose View more row actions.
  4. Pick Protect range.

Can you lock a Filter View in Google Sheets

  1. Enter a description for the highlighted section.
  2. Click on the Set permissions button.

Set permissions button

  1. Select the user(s) who can edit this range. 
  2. Tap Done.

Range editing permission

Congratulations! You have done it!

More Google Sheets Tutorials
More Microsoft Excel Tutorials
Share This Post
Daniel Smith
Daniel Smith
Daniel Smith is automation consultant with a passion for technology, data, AI, and machine learning.

The Spreadsheet Daddy add-on rebrands to Synterrix. Click here to learn more.

X