How does Excel filter work?

Source: Internet
Author: User

 How does Excel filter work? Now, many people are using Office software. And in the face of a large data table, how to quickly display the required data? You will certainly consider this feature. So, how does Excel filter work? Below, small series to tell you about Excel more than 2013 pieces of the use of filtering.

① First, we open a data table to filter out the options for the amount greater than 400 in north China. Click the menu bar--Data--advanced.

Excel Filter

② The Advanced Filter dialog box, we select the result display, which is displayed in the original area, that is, the original data is not preserved. The following is shown in other locations, preserving the original data for easy comparison and viewing.

Excel Filter

③ List Area We choose A1:e9, which is the data area in the original table.

④ then is the selection of the criteria range, select G1:h2, and click OK.

Excel Filter

⑤ table data has changed, listing the options in North China that are greater than 400.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.