Autofilter blue indicator arrow showing on wrong column

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top