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

Published: 03 November 2020
on channel: Leila Gharani
232,242
2.6k

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...

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.

👉 Join My Google Sheets Comprehensive Masterclass HERE: https://www.xelplus.com/course/google...
*** 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

Link to the complete article: https://www.xelplus.com/google-sheets...

Sheets Vs Excel video:    • Google Sheets BEATS Excel with THESE 10 Fe...  
Should you learn Google Sheets video:    • Top Reasons Why You Should Learn Google Sh...  

★ My Online Excel Courses ► https://www.xelplus.com/courses/

➡️ Join this channel to get access to perks:    / @leilagharani  

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

🎥 RESOURCES I recommend: https://www.xelplus.com/resources/

🚩Let’s connect on social:
Instagram:   / lgharani  
LinkedIn:   / xelplus  

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


Watch video Filter Views - How to Filter Google Sheets Without Affecting Other Users online, duration hours minute second in high quality that is uploaded to the channel Leila Gharani 03 November 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 232,242 times and liked it 2.6 thousand visitors.