Excel 2007 Filtering range


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
 
Ad

Advertisements

R

Ron de Bruin

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 ?
 

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