Filter Option

Hi,

If someone could help me with the Auto Filter option.

I have 8000 records in a worksheet. If I choose Auto Filter option and
click drop down button I am able to view only 1000 records and not more
than that. If I need to view all the records. How can I do it and what
is the option?

Debra Dalgleish exhibits some options at her Contextures website:

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

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"saraskandan@gmail.com" wrote:

> Hi,
>
> If someone could help me with the Auto Filter option.
>
> I have 8000 records in a worksheet. If I choose Auto Filter option and
> click drop down button I am able to view only 1000 records and not more
> than that. If I need to view all the records. How can I do it and what
> is the option?
>
>

Is there any other way to increase the limit....

There may be other workarounds, but there's no setting you can change to
increase the 1000 item limit.

saraskandan@gmail.com wrote:
> Is there any other way to increase the limit....
>


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html