Use filters in Microsoft® Excel 2010 to view your data in different ways

The most versatile way to search for or display data in Excel 2010 would be by using filters. If the data you are searching for is organized and doesn’t need complicated search queries, filter is the most hassle free way to go.

In the figure below, the sales data for different products for a given year is documented. Now, let’s say that you have to get the data for product K and product T.

 

 

 

 

Let us see how you could do that.

1. First, you need to select the data range
2. Now, select the ‘Data’ tab on the ribbon
3. Next, look for the option filter
4. Click ‘Filter’ to get the filters for the table

Now that you have enabled filters, you would see drop down keys on top of each column that give you the menu for options when you click them.

 

 

 

 

 

 

 

 

 

Now, if you have to get the data just for the products K and T, you should click the filter key on the product column. Once you click the filter key, you would see that the option ‘select all’ is checked. Uncheck the option ‘select all’ and just select the products for which you need the data, which in this case is K and T.

 

Once you select the products from the drop down menu, click ‘OK’.  And this is what you will see:

 

 

Isn’t that extremely simple? Use this to see just the data you want to see when you have it in large volume.