How to use the filter option in Microsoft excel?

Asked By Trish Martin 60 points N/A Posted on - 08/21/2012

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.

• Status: Open
• Question Views: 1130
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #145251

How to use the filter option in Microsoft excel?

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.

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.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel

Answered By tathanhxuan 0 points N/A #145252

How to use the filter option in Microsoft excel?

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) https://www.wikihow.com/Use-AutoFilter-in-MS-Excel

2) http://www.contextures.com/xladvfilter01.html

3) https://bettersolutions.com/excel/tables/tables.htm

Enjoy it.

About tathanhxuan

Questions
0

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/07/2012
• Question Category: MS Excel