Autofilter - No. of Rows

[Me!]

Does anyone know of any way to increase the number of rows displayed in
Autofilter, becauase when working on large ranges it doesn't display all
values.

Any help greatly appreciated.....

 

[Pete_UK]

There is a limit on what can be displayed in the filter pull-down of
1000 items. However, you can still apply filters to values that can
not be seen. Debra Dalgelish gives some techniques here:

http://www.contextures.com/xlautofilter02.html#Limits

Hope this helps.

Pete

 

[Alan]

The limit is 1000 rows (in 2003 anyway, not sure about 2007), and I don't
think it can be increased. There are some good work rounds here,
http://contextures.com/xlautofilter02.html#Limits
Regards,
Alan.

 

[Me!]

Thanks guys...Most appreciated,

The limit is 1000 rows (in 2003 anyway, not sure about 2007), and I don't
think it can be increased. There are some good work rounds here,
http://contextures.com/xlautofilter02.html#Limits
Regards,
Alan.