How Excel filtering functions using

how Excel filtering functions using

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

Excel

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.

Excel

Excel

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:

Excel

Excel

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, just click on the "Performance" heading of the Drop-down arrow, from the Pop-up extended menu select the "Number Filter"-"" greater than or equal to.

Excel

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

Excel

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.

Excel

Excel

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.

Excel

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

Excel

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"-"Remove" item.