jana
asked on
Identify if an Excel with lots of columns filtered, any has been set
We have an Excel that has a series of columns as filters and want to know if a "filter" has been set without going column by column to identify it. Usually, when there are maybe 5 or 10 columns, we just look for the upside-down triangle which indicate a filter has been set in that column, but this excel has a lot of columns. Or, we just disable the filters and then select columns >> enable filters again.
Is there a way that we can know that a filter has been set? (we don't need to know the actual column only if there has been any set).
Is there a way that we can know that a filter has been set? (we don't need to know the actual column only if there has been any set).
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could also add Conditional Formatting, maybe to just the headers. This would use a formula comparing a COUNT with a SUBTOTAL. The COUNT will count all rows whereas the SUBTOTAL will only count visible rows.
ASKER