I recently started to learn about Microsoft excel. I heard about many options available in excel. Further I heard using filter option we can do a lot of works in excel. Can anybody explain me how to use filter option in excel.
- Login or Signup Now to post comments
What you have heard about Microsoft excel is absolutely correct. Using filter option we are able to do a lot of works in excel.
I will show you how to apply filter option for an excel data series and different usage of the same.
Please see the below image.
In order to apply filter option for the given example, first select the entire table.
Then click on the data tab and click on the filter icon as shown in the below image.
Now filter option has been shown in each heading.
Now click on that filter button as you want. I will click on the “Age under” heading’s filter button.
And deselect all and select the “20” as follows. After, click ok.
Now you can see the age under 20 names have been filtered as follows.
As such you are able to use this option as you want.
Hi Trish,
Filter option in excel is the way you can see your data in some columns, some rows, some sheets following your filter condition.
About the type of filter option or how to do it, you can see it on many pages. Following is some examples:
1) http://www.wikihow.com/Use-AutoFilter-in-MS-Excel
2) http://www.contextures.com/xladvfilter01.html
3) http://www.bettersolutions.com/excel/EDZ483/QT419412321.htm
Enjoy it :D.