Is there a limit to the number of rows that can be filtered

[W Paul]

In Excel 200o, is there a limit to the number of rows that can be filtered?
I'm having a problem where Excel filters everthing before row number 1155,
but from 1155 forward, it not filtering and including all data from that row
forward.

 

[Max]

Believe 1000 is the limit for items to display in the autofilter droplist ..

Try Debra Dalgleish's coverage on this at her page:
http://www.contextures.com/xla­utofilter02.html#Limits
for a possible workaround
(Look under "Limits to Dropdown Lists")

 

[Gord Dibben]

Another point.

You may have a blank cell or row at 1155.


Gord Dibben Excel MVP

 

[Max]

Good point, Gord. Thanks.

Think I probably mis-read the original post
(realized upon a closer re-read ..)

OP: Perhaps try selecting the entire range to be filtered,
i.e. inclusive rows > row1155 before effecting autofilter?
This should pull it in ..