Autofilter quirk

  • Thread starter Thread starter PaulButler
  • Start date Start date
P

PaulButler

I have come across a strange "problem" when using Autofilter. Whatever I
do Row 1 is ALWAYS displayed irrespective of whether or not it contains
the filtered data. I have been unable to find any match to this via the
web and wonder if anyone has come across this before and , if so , what
did you do to solve it?

I'm using Excel 2002 (10.4302.4219) SP2

Thanks
 
PaulButler said:
I have come across a strange "problem" when using Autofilter. Whatever I
do Row 1 is ALWAYS displayed irrespective of whether or not it contains
the filtered data. I have been unable to find any match to this via the
web and wonder if anyone has come across this before and , if so , what
did you do to solve it?

I'm using Excel 2002 (10.4302.4219) SP2
Click to expand...

I think this is because Excel treats row 1 as the headers rather than part
of the data area. Include a header row above your data in the area you are
filtering (even if this is left blank) and your problem will disappear.
 
Back
Top