How Excel filtering functions using

Source: Internet
Author: User
Tags remove filter sort

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.