Why can't I filter out some items during filtering?

Solution: First open the excel table that needs to be operated; then click the "Data" tab on the toolbar at the top of the page and select the "Advanced" option; then select all the tables that need to be filtered; finally click "Filter" ” twice to filter the complete list.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

First look at the filter list and the corresponding data, as shown in the figure below, there is data content in the filter list

Leave a blank line, enter 29, 30, In the filter list, you will find that the two values ​​​​29 and 30 are missing. The reason is that there is a blank row.

Enter the data in the blank row, and the filter list has also changed. Now, with the two values ​​​​of 29 and 30

Click "Advanced Filter" next to "Filter" and carefully observe the list area. It is not difficult to find that the area does not include 29 and 30. The data.

Therefore, select all table contents and click "Filter" twice, and a complete filtered list will appear

Related learning recommendations: excel tutorial

The above is the detailed content of Why can't I filter out some items during filtering?. For more information, please follow other related articles on the PHP Chinese website!