Excel 2007 Filtering range

  • Thread starter Thread starter akrukis
  • Start date Start date
A

akrukis

Hi,

I have a list in Excel 2007 that I have applied an auto-filter to.
For some reason the auto filter (when I run it) only applies to a
certain number of rows. At the bottom of the filtered data remnants
of unfiltered data remains.

Anyone experience this? I tried converting the range to a table.
Making it a named range. Turning the auto-filter on and off -
nothing.

Any help would be appreciated.

Thanks
 
Hi

If there is a empty row in the table you have this problem
If you select the whole table first do you have the same problem then ?
 
Back
Top