We use large Excel files with filters. I waste time scrolling across columns
to make sure what filters are still on or off. Is there a feature in Excel
where you can
look to see what columns have filters on them?
Unfortunately, the only built-in feature Excel offers is a nearly
imperceptible color change of the filter arrow from black to dark blue.
Unless you've got great eye-sight, this probably isn't very helpful.
Here's a User-Defined Function that I got from this forum that I use on most
of my sheets that have lots of AutoFilters. Create a module for your
workbook, then copy this code into it.
Function FilterCriteria(Rng As Range) As String
Dim Filter As String
Filter = ""
On Error GoTo Finish
With Rng.Parent.AutoFilter
If Intersect(Rng, .Range) Is Nothing Then GoTo Finish
With .Filters(Rng.Column - .Range.Column + 1)
If Not .On Then GoTo Finish
Filter = .Criteria1
Select Case .Operator
Case xlAnd
Filter = Filter & " AND " & .Criteria2
Case xlOr
Filter = Filter & " OR " & .Criteria2
End Select
End With
End With
Finish:
FilterCriteria = Filter
End Function
I then insert a new row above my Filter heading and use this formula:
=IF(filtercriteria(A3)="","(none)",filtercriteria(A3))
HTH,
Elkar
> We use large Excel files with filters. I waste time scrolling across columns
> to make sure what filters are still on or off. Is there a feature in Excel
[quoted text clipped - 9 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=524c4752-8b93-4
5bf-9828-40606d7542b3&dg=microsoft.public.excel.worksheet.functions
No, apart from the blue arrows in the filter dropdowns.

Signature
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
> We use large Excel files with filters. I waste time scrolling across
> columns
[quoted text clipped - 12 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=524c4752-8b93-4
5bf-9828-40606d7542b3&dg=microsoft.public.excel.worksheet.functions