J
Johnboy
Hi,
I have an Excel 2002 SP3 spreadsheet containing a status report with 25
columns and less than 100 rows. The status report table has an autofilter
applied to it.
Normally when you apply a filter using the autofilter drop down for any
column, the indicator arrow for the column that is filtered turns blue.
However, in my spreadsheet it doesn't - the autofilter arrow two columns to
the left turns blue, which is really confusing if you then want to show all
rows again!
This happens periodically and the only way to reset it is to remove and
re-apply the autofilter to the whole table.
Has anyone else encountered this? Is there a fix or an underlying issue?
TIA!
I have an Excel 2002 SP3 spreadsheet containing a status report with 25
columns and less than 100 rows. The status report table has an autofilter
applied to it.
Normally when you apply a filter using the autofilter drop down for any
column, the indicator arrow for the column that is filtered turns blue.
However, in my spreadsheet it doesn't - the autofilter arrow two columns to
the left turns blue, which is really confusing if you then want to show all
rows again!
This happens periodically and the only way to reset it is to remove and
re-apply the autofilter to the whole table.
Has anyone else encountered this? Is there a fix or an underlying issue?
TIA!