How to Create Filter in Excel

Welcome in this video tutorial .

We'll cover how to create a filter in Excel .

At the end of the session , you'll be able to filter out relevant data within the table effectively .

Let's have a look .

Hello and welcome to easy click Academy .

My name's Frank .

And together with the easy click team , we're here to make sure you'll be able to use Excel in a quick and easy way .

Thanks to our digestible video tutorials to see how to create a filter in Excel .

We'll use this table as an example .

The first thing to do if you want to use the filter function in the table is to use headers to select the columns in which you want to apply the filter .

Let's select the headers , month days and season .

Now click on the data tab and look for the group sort and filter .

Then find and click on the filter option .

Excel will create these dropdown arrows or buttons in the cells containing the headers of the selected columns .

You can use the buttons to filter out the information you need in each column .

Now it's time to take a step forward and try out the filter we've just created in practice .

Let's say we want to filter out only the summer months , click on the dropdown arrow in the column season .

All of the options are selected by default unselected .

The options by clicking on select all .

Now tick the box next to the option which we want to filter out , which is summer .

Confirm with .

OK .

And you see that only the summer months are now displayed in the table .

If you have a look at row numbers , you'll see that the rows with data for other months have not been deleted .

They're only hidden .

Look , there's row two and rows 89 and 10 .

Follow right after then the next row number you can see is 15 .

Now we can carry on .

Imagine you need to do some more filtering .

Let's say you want to filter out months that have 31 days only .

We'll do what you're already familiar with .

Click on the dropdown arrow in the column days , click on select all and once everything's been unselected , tick the box for only those months that have 31 days .

So select 31 click on .

OK ?

And here we go , we've used filter to show only those summer months that have 31 days easy , right ?

You can follow these steps to filter out data in any table .

You need to see how you can remove the filter from the table .

Watch the next video tutorial by easy click academy .

If you found this tutorial helpful .

Give us a like and watch another video tutorial by easy click academy .

Learn how to use Excel in a quick and easy way .

Is this your first time on easy click ?

We'll be more than happy to welcome you in our online community .

Hit that subscribe button and join the easy clickers .

Thanks for watching and I'll see you in the next video .