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

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

On Mar 10, 1:39*pm, "Me!" <du...@dummy.dummy> wrote:
> 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.....

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!" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.....
>

Thanks guys...Most appreciated,


"Alan" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.....
>>
>