187k views
5 votes
In Excel, how many columns can be filtered at a time?

1 Answer

12 votes

Answer:

When you apply the Filter function, after filtering one column, the next columns will be only filtered based on the result of the previous filtered column. It means that only AND criteria can be applied to more than one column.

Step-by-step explanation:

Hope it helps you!

User PeterBe
by
6.0k points