Excel 2007 Filtering range
 

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

Excel 2007 Filtering range
 

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 ?

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
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