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
 
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

Similar Threads

Problem with filtering columns in Excel 2007 1
Getting no results from Advanced Filtering in Excel 2007 1
Delete Filtered Rows in Excel 2007 7
Excel 2007 compatibility issue - speed between cells 2
filter range 2
Auto-filter includes too much range 4
Return value from the top of an auto filer list. 1
Auto Filter in EXCEL 2007 4

Top