How to use the filter option in Microsoft excel?

Asked By 60 points N/A Posted on -
qa-featured

I recently started to learn about Microsoft excel. I heard about the many options available in excel. Further I heard using the filter option we can do a lot of work in exile. Can anybody explain me how to use the filter option in excel.

SHARE
Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #145251

How to use the filter option in Microsoft excel?

qa-featured

What you have heard about Microsoft excel is absolutely correct. Using filter option we are able to do a lot of work in excel.

I will show you how to apply filter option for an excel data series and different uses of the same.

Please see the below image.

Filter option in Excel

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.

Enable Filter

Now filter option has been shown in each heading.

Filter Data Series

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.

Auto Filter options

Now you can see the age under 20 names have been filtered as follows.

Filter option in Excel

As such you are able to use this option as you want.

Answered By 0 points N/A #145252

How to use the filter option in Microsoft excel?

qa-featured

Hi Trish,

The 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 doing it, you can see it on many pages. Following are 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.

Login/Register to Answer

Related Questions