Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

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).
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Wow, thank you very much!  I have looked and looked and never noticed it! You have saved us a lot of work!
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.