Excel Automatic Filtering Tips

The first two days require a short period of time to summarize the data in the Excle table, but found that the function of automatic screening can not be used, anxious a head of sweat, fortunately found in time, the table has empty lines, immediately after the removal of the filter function, summed up the previous experience, can not be filtered and filtered data is mainly caused by the following factors.

1 There are blank lines in the data, resulting in the following blank line can not participate in the selection;

Workaround: Delete blank lines;

2 has been added to a number of other columns or columns, resulting in the selection of a numbered column, only to see the filtered part of the data;

Workaround: You can check to see if the filter is added to the other columns, and if you don't, remove the AutoFilter and then add the AutoFilter back to the menu.

3 A branch has been manually set up to hide, so that when the selection of filtering will not see this part of the data;

WORKAROUND: Select all rows, right-click to unhide, or select (All) in the AutoFilter drop-down list to check to see if all of them are out.

4 There are merged cells in the table, resulting in incomplete filtered data

WORKAROUND: Restore merged cells.