How does the Excel filtering function work?

How does the Excel filtering function work?

1, first select the range of data you want to filter, this area should also include the title bar, and then click the "Sorting and Filtering"-> "Filter" item.

2, you will find in the title bar display "Drop-down arrow." Click the appropriate Drop-down arrow to select the item you want to filter, and click the OK button.

3, at the same time also supports multiple conditional filtering, only need to set the individual headings of the filter items can be. For example, when we filter "male", "agent" when the results of the filter as shown:

4, in addition to the number, but also provides a conditional filtering function. For example, when we need to select "Performance greater than 80" employee information, we only need to click the "Performance" heading of the Drop-down arrow, from the Pop-up extended menu select "->" "" is greater than or equal to the item.

5, and in the pop-up window input "80" and click "OK" can be.

6, at the same time also supports "Filter by Color", only need to click the Drop-down arrows, from which select "Filter by Color", and select the appropriate color to achieve the filtering function. Of course, the prerequisite for implementing this step is that the unit has been set with a background color.

7, in the use of screening process, there is also a use of skills, is the elimination of screening conditions. There are two ways to eliminate filtering: one way to do this is to check all the options in the Drop-down list of headings that you want to eliminate.

8, another way to do this is by selecting Remove Filter from from the Drop-down list of headings you want to eliminate.

9. When we need to eliminate all the filtered items in the zone, we can eliminate all the filtered items by clicking the "Sort and filter"-> "elimination" item.

Word Tutorial

Excel Tutorials

PowerPoint Tutorials