Itqualityassurance
How can I fix Excel table filtering?
- Launch Microsoft Excel.
- Open the file where the filter is not working.
- Select the table's whole spreadsheet column by clicking the column's letter.
- Navigate to the Data tab.
- Then click the Filter button to apply the filter to the whole column.
Why is Excel not filtering the whole column?
Check that a filter hasn't been left on another column. The best way to clear all of the filters is to click the Clear button on the Ribbon (to the right of the Filter button). What is this? This then leaves Filter turned on, but removes all filter settings allowing you to start again with the full set of your data.
Why is my Excel filter not including all rows?
Filter not working in Excel
To fix this, simply re-apply filter. If that does not help and your Excel filters are still not working, clear all filters in a spreadsheet, and then apply them anew. If your dataset contains any blank rows, manually select the entire range using the mouse, and then apply autofilter.
