I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

Select the entire col(s) before you apply autofilter. Any blank cells/rows
in-between data lines will "break" autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NanoMark" wrote:
I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

The autofilter drop-down list will show only 1000 items.

You have to work around by using "Custom" and choose from options there.

Contains..........Greater Than..........Equal to...............and more.

See Debra Dalgleish's site for more workarounds to this limit.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP



On Wed, 18 Oct 2006 16:44:01 -0700, NanoMark
wrote:

I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

Thanks Max, but no blanks or breaks in the data. Apparently there is a 1000
record limit to the drop down autofilter list (see post after yours).

"Max" wrote:

Select the entire col(s) before you apply autofilter. Any blank cells/rows
in-between data lines will "break" autofilter.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NanoMark" wrote:
I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

Thanks Gord. This answers my question, even if I don't like it! I think the
custom option will be the way to go, it's just harder to train users on that
option.

Regards,

"Gord Dibben" wrote:

The autofilter drop-down list will show only 1000 items.

You have to work around by using "Custom" and choose from options there.

Contains..........Greater Than..........Equal to...............and more.

See Debra Dalgleish's site for more workarounds to this limit.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP



On Wed, 18 Oct 2006 16:44:01 -0700, NanoMark
wrote:

I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

Thanks for the feedback.

This has been a "can you change it" item for quite a while.

I don't know if 2007 beta has made any modifications or not.


Gord

On Thu, 19 Oct 2006 15:32:02 -0700, NanoMark wrote:

Thanks Gord. This answers my question, even if I don't like it! I think the
custom option will be the way to go, it's just harder to train users on that
option.

Regards,

"Gord Dibben" wrote:

The autofilter drop-down list will show only 1000 items.

You have to work around by using "Custom" and choose from options there.

Contains..........Greater Than..........Equal to...............and more.

See Debra Dalgleish's site for more workarounds to this limit.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP



On Wed, 18 Oct 2006 16:44:01 -0700, NanoMark
wrote:

I have a spreadsheet with over 3500 rows (not really a lot) but the
Autofilter drop down list does not show them all. It only shows approximately
2400 rows. Is there a limit to the number of rows that autofilter can be used
on?

No prob. Thanks for feedback.
Guess I mis-read. My focus was on your line:
.. It only shows approximately 2400 rows.

Gord's reading & response was spot on <g
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NanoMark" wrote in message
...
Thanks Max, but no blanks or breaks in the data. Apparently there is a
1000
record limit to the drop down autofilter list (see post after yours).