When a filter is active, the Filter button at the top of the table shows how many filters are on, for example Filter (1). Next to it you can see how many lines are shown out of the total, for example 12 of 22 lines. You remove all filters with Clear all filters.
How to see that a filter is active
The button at the top shows the number of filters, for example Filter (1).
At the top it says how many lines are shown out of the total, for example 12 of 22 lines.
The filter icon in the header of the filtered column is highlighted.
How to remove filters
All filters: Click Clear all filters at the top of the table.
One filter: Open the filter menu in the column header and click Clear.
Why can I only filter on columns that are shown?
You can only filter on columns that are visible in the table. Previously a filter could sit on a hidden column, and it looked as if rows were missing with no way to see why. If you want to filter on a column you don't need to see, you can show it and move it all the way to the right.
Good to know
The summary line at the bottom shows how many lines are shown, for example Sum · 12 lines. If the number is lower than you expect, a filter is probably on.