Filter Views - How to Filter Google Sheets Without Affecting Other Users

With the Filter feature in Google Sheets you can analyze data by showing only the information you want. But applying these filters changes what others see in the file, too. And because Google Sheets is a collaborative cloud-based spreadsheet, you may want to filter data without changing the original data and impacting others who might be working on the data.

What is a Filter view in Google Sheets?
That's where the super helpful Filter Views come in! With Filter Views in Google Sheets you can apply the filter conditions of your choice without changing the original spreadsheet view. With Filter Views you can also sort the data without changing the original sort order of the data. In addition, you can save and name this filter view for easy access in the future. Filter views can also be used by your collaborators. You don't even need to activate Filter to use a filter views. Once saved, they can be accessed anytime.

*** Additional Bonuses are ONLY available on XelPlus. Check the course landing page for more info.

00:00 How To Filter Data in Google Sheets
04:28 How To Create Filter Views in Google Sheets
04:50 Sort data in Filter View
07:56 How To Filter by Color in Google Sheets
09:11 Google Sheets Comprehensive Masterclass

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets

[djones]

Very concise and straightforward. I was able to quickly create a filter view in a shared data, even though this is new to me. Thank you, Leila!

[Betterifitsfree]

I usually get these posts in the morning so during the day I can try them out for myself. So cool, so helpful, the way life should be. Thanks so much Leila for your efforts.

[lucy_]

This was incredibly helpful. Thank you for explaining filters so clearly!

[aminlast]

You rescued our department not to interrupt each others' works.
Thanks

[maproductions]

I am watching this for the 10th time, and every time i watched it, learned a new thing about filter views! one the best illustration of How to use Google Sheets!

[thinkthinktechs]

You are google sheet icon, your tutorials have made me a master.Thanks for your amazings staffs Leila

[nightfallalicorn]

This is the solution for the issue I've been having with my spreadsheet. Thank you so much. I've been adding extra spreads with the filter function but I believe filter view reduces the spreadsheet size and improves performance. As well as make it cleaner.

[kevindillman]

Can you pop up a dialog box to ask what to filter? Something like this would give on-the-fly filtering a little more power.
By the way, your videos are amazing! I have worked as a data analyst for over 12 years and have learned a lot from you.
Keep the great videos coming!

[wohinmitdemgeld]

I really admire and enjoy the professionality of your videos. Always useful, practice oriented, to the point. Thank you!

[gzwtmph]

Thank you for explaining the difference between sort and filter. I was extremely frustrated to see the filter modify the Excel from the beginning, but now I have a better idea.

[DougHExcel]

Filter view is sure a neat option when collaborating!

[nperry]

That was excellent thanks very much. I was able to work out the number of patients seen in a given time without upsetting my dataset.

[faridi-bin-Zouq]

after watching this video.... " oh wao " was my reaction... Thanks --From Pakistan

[Iam_sami_]

Such a great tutor, i will definitely purchase your course on Udemy.

[marcotanini]

Dear Leila, thank you for your valuable advice, always well explained. My use of gSheeet has dramatically improved and my work has become much more productive.

[gracemark]

i never knew it o.my.god filters are available in google shetts this is helpfull👍👍

[Evildaddy]

Thanks! I've never understood how to use filter views until now. I've had extra sheets dedicated to common filters but now can do it all in one

[zahiragamal]

your videos are incredible, more plz!

Leila, thanks a lot for such an informative video. Big thumbs up! 👍👍

[FerdiCildiz]

awesome, thank you. that's what I'm exactly looking for.