How to Filter a Report in Microsoft Excel.

The basic Excel filter allows you to view specific rows in an Excel spreadsheet, while hiding the other rows. Filter is one of the most powerful feature in M S EXCEL for DATA ANALYSIS. There are many types of filters in Excel like Text Filter, Number Filter, Date Filter.

Here I am going to show you few types of Filter.

First of all you have to create a TABLE in which you want to apply filter and click anywhere in table.

after creating table select option filter from DATA Tab.

or You can select option from HOME Tab also.

after applying filter you can see arrows inside the heading cells.

Now your file is ready for filter... 

Filter of Single Data:-

If you want to filter a single data from a column that is called Single data filter. for this you have to click on ARROW inside heading from you want data.

As you can see in picture below filter option will be appear like this.

In this you can enter required Data. in search box.

and then press enter.

As you can see in picture below the result will be showing like this and the ARROW sign converted in to FILTER.

You can clear filter from-

1. DATA tab.       2. HOME tab        3. Filter Sign.