Filters in Excel

In this lesson you can learn how to use filters in Excel.

 

Excel has a feature of filters that make it easy to perform various operations on the data in your spreadsheets. They allow you to view and optionally print only selected data from the table, and perform mathematical operations, taking only the visible data. Let’s see how to use the filters in Excel.

Example – easy filtering by category in Excel

You will use a table of products which filters them by category.

Filters Table Example

Select the table header row.

Filters Table Header Row

Go to the Ribbon. In the Home tab, click the Sort & Filter icon and select Filter from the list.

Filters Ribbon

In the table appeared some buttons to filter the data.

Filters Buttons

Click on the Categories. In the list untick the category which you want to be hidden (filtered), such as Category2.

Filters Categories Filtering

After applying a filter, you can’t see products from Category2.

Filters Category Hidden

On the picture above you can also see that some rows are hidden. You don’t see 3 and 10 row. In the B1 cell you can also see a symbol of filter close to the arrow. That means that this column is filtered.

If you want to filter more you can. Let’s hide products from Producer3 and Producer5.

Filters Producers

You can also filter prices. There’s more number filters. Click filter arrow in D1 cell.

Number Filters

I want to find the cheapest. I select Less Than Or Equal To.

Filters The Cheapest

My budget is $150.

Custom AutoFilter

That’s how I filtered out products which I don’t want in my table.

Filters Ready

Now it is much easier to choose one.

Template

You can download the Template here – Download