Google Sheets Beginners: Filter (38) & Filter View (39)

38 - Google Sheets Shorts - Filter

In these video tutorials, we will cover the Filter tool in Google sheets.

Filter

You can set up a specialised view of your Google Sheet data that will let you sort, or filter out unwanted data in any column with the Filter tool.

This tool can pack a punch. You can sort different columns alphabetically, numberically, suing custom rules or even background colours. You can then use the filter part of the tool to remove unwanted parts of your data.

Don’t worry though, the filter will not affect your original. All you have to do is remove the filter and your data is back to normal.

In this video tutorial, we will go into the details on how to use the Filter tool. We will also cover some common gotchas, that beginners stumble on when trying to use Filter for the first time.

Check it out:

Watch this video on YouTube.

00:00 Intro
00:26 Accessing the Filter tool
01:14 About column headers and Filter
01:26 Fixing up hidden headers
01:39 A basic sort
01:46 Sorting A-Z & Z-A
02:00 Sorting with numbers
02:28 Sort by a background colour
03:09 Sort by order then colour
03:34 Sort by multiple columns (gotchas!)
04:23 Sort by grades
05:25 Filtering
05:34 Filter by values
07:46 Filter by colour
08:27 Filter by condition

Filter Views

You can create a variety of different filtered views without code or changing your data with Google Sheets Filtered Views. These views can be really handy for quickly presenting your data to your team or clients.

Take a look at the video:

Watch this video on YouTube.

00:00 Intro
00:17 How to create a Filter View
00:44 Filter view layout
01:03 Create your first Filter View
01:32 Updating the range
02:48 Accessing & hiding Filter Views
03:07 Create another Filter View
04:13 Duplicating a Filter View
05:57 View a list of Filter Views
06:21 Remove a Filter View
06:41 Educating your team

If you enjoy the videoes and want to learn more about how to use Google Sheets, check out the Youtube Playlist:

Google Sheets Shorts: Beginners

Want a quick reference to the top shortcuts? Check out these handy mousepads.

 

Want a solid step-by-step course to become a pro at Google Sheets? Udemy has some professional courses that will turn you into an admin ninja!

I’m a huge fan of Justin Mares, Mastering Google Sheets course. Sign up today*

 

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website. 

Leave a Reply