A detailed tutorial on filtering specified data in an Excel table

In the application of Excel, sometimes in order to better find, compare or display a certain period of time, a content of the data, we often use the function of filtering, only need to filter out the data they need to hide other data. Below, small knitting to teach you to use the header row for table information filtering, detailed see the specific steps of the operation.

1, click the "Data" button in the upper Ribbon, select "Filter" In the Expanded tab, and select AutoFilter in the Filter tab.

2, we can see the filter button in the header row, click the title of the content you want to filter, such as: year

3, in the open list, according to the need to select their own needs to filter out the data, such as 1978

4, when the data is too much, the Drop-down tab is too cumbersome, you can click the Options box in the Custom option.

5, at this time, will pop up a "Custom AutoFilter" dialog box, according to their needs to fill in the content, such as small series want to filter out the year for 1978 years of GDP data, select the year "equals"--"1978", if you want to choose 1978 years later, you can choose "Greater than"

6, click OK, close the dialog box, return to the worksheet, you can see the Excel table only the year 1978 years of data to display.

7. If you need to reproduce the filter content in the format, you can click on the "Year" filter button in the header row, select "All" in the Open list, and click OK.

8, you can put the data on the worksheet all show up.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join