How does the smart search filter in Excel 2010 work?

Source: Internet
Author: User
Excel 2010 improves data filtering by leveraging its All-new search filter users to quickly search for target data from large datasets with only a small amount of time.


Operation Steps:

1. On the Open Excel 2010 worksheet, switch to the Data tab, and in the Arrange and filter Options group, click the Filter button to enable cell filtering, as shown in Figure 1:

2, you can filter the data by clicking the Filter button on the Title field, and then by canceling or selecting a check box in the Drop-down list, as shown in Figure 2:

3, unlike earlier versions, there is a "search" text box in the Drop-down list, which is the new search filter in Excel 2010, which allows us to intelligently filter the corresponding data and enter keywords in this text box to intelligently search for the target data. You can enter a single word or number you want to find to complete the search, as shown in Figure 3:

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.