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

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.

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"W Paul" <W wrote in message
...
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.

Another point.

You may have a blank cell or row at 1155.


Gord Dibben Excel MVP

On Mon, 7 Mar 2005 10:10:11 +0800, "Max" wrote:

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"W Paul" <W wrote in message
...
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.

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Another point.

You may have a blank cell or row at 1155.