How to use Excel spreadsheet? Excel filter using graphic tutorial

How to use excel filtering? Nowadays, many people are using office office software. How do you quickly display the data you need in the face of a large data table? You will definitely consider filtering this feature. So, how to use excel filtering?

Below, Xiaobian will tell you about the use of excel 2013 multi-condition screening.

1. First, we open a data table to filter out the options for amounts greater than 400 in North China. Click on the menu bar -- Data -- Advanced.

2. Pop up the advanced filter dialog box, we select the result display mode, the above is displayed in the original area, that is, the original data is not retained. The following is displayed in other locations, retaining the original data for easy comparison.

3. List area We select A1:E9, which is the data area in the original table.

4. Then select the condition area, select G1:H2 and click OK.

5. The table data has changed, and all options with a value greater than 400 in North China are listed.