How do you use the Data filtering feature in Excel?

In the process of using Excel, when there are many data in the table, it is difficult to find the information you want to find yourself. At this point we need to use the data filtering function in Excel, through the filtering function can quickly find the data we need. So how do you use the Data filtering feature in Excel? The next small series according to their own experience to say the use of screening function, I hope to help you!

Software Name: Excel2003 Green version EXCEL2003 Lite Green version (with excel2003 green tools) software size: 13.3MB update Time: 2012-06-19

Steps

1, first open the Excel spreadsheet we want to view! We find that there are so many data in this area, how can we find the data we need quickly?

2, we click on the data in the menu-filter, and then select Automatic Filter!

3, we now want to filter the conditions, such as small series to be screened according to the school! Then I will be in the school key to the right click on the small arrow, and then appear in the Drop-down menu to find the school we are looking for!

4, so we are looking for all the information displayed!

5, of course, this method is also more skills, such as I want to find a student's results, we can click on the right side of the name keyword small arrow! Then choose Custom!

6, in the custom automatic screening method we enter the student's name, then determines!

7, so we entered the name of the students have been shown, of course, if the same name of the students will now here! And you find yourself to find that classmate on it!

8, when we have finished using the automatic filtering function, we can put the data-filter-automatically filter the front of the check to cancel on it!

The above is in Excel how to use the Data filtering function method Introduction, the operation is very simple, everybody according to the above steps carries on the operation then, hoped can have the help to everybody!